Error on installing Oracle 10 software where Oracle 9i software already exists

Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...

Wbuker0 pointsBadges:

Is it possible to install multiple Oracle 10g instances from one installation?

I would like to know if it is possible to install multiple Oracle 10g instances from one installation, or if we have to run the installer every time to create a new instance. If it is possible, how is it done?

OracleATE190 pointsBadges:

How to set Oracle database path with Oracle Developer

How do I set an Oracle database path with Oracle Developer?

Orcl5 pointsBadges:

Oracle log for table update

I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. In last 10 days one user connected to Oracle database other than regular forms 6i program and modified one table record column value by update....

Mbv30 pointsBadges:

Regarding networking Oracle 10g on Linux

Hi, This is regarding how to configure listener.ora and tnsnames.ora. Can anybody please help me? Thank you.

manu19815 pointsBadges:

Tuning Oracle library cache

What are the steps involved in tuning Oracle's library cache?

Fsdfsdfsdfsdfasdfsd5 pointsBadges:

Most common Oracle DBA tool

Which tool is most common for database (Oracle) administration, instead of OEM?

Aqmemondba80 pointsBadges:

SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

IdongesitDaniel5 pointsBadges:

Oracle installation and migration between versions in Linux

Hi Experts, I need some useful doc links or step by step procedure to perform Oracle installation and migration in Linux environment. I surfed through the NET and could not find any good docs or PTF on this. As I'm new to explore this role, can any one provide me some useful related links?

Inprise610 pointsBadges:

Change user password for Oracle Internet Directory

I have to change the user password cn=orcladmin for internet Oracle directory. How?

Army125 pointsBadges:

How to pass parameters from Oracle Form to Oracle Report?

how we can run oracle repoert from Oracle form and passing parameters from form to oracle report by Clicking Button

Saeed5 pointsBadges:

SQL Server restore job fails

I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...

TuftsDBA0 pointsBadges:

Oracle Forms 6i next button coding

I need to know the coding for NEXT BUTTON in oracle forms 6i, when the fields are not database items....I want to fetch next record after pressing NEXT BUTTON...I have applied select query and tried to store the fetched records in fields of the form....but in vain...i got no output in the...

Yahoo9superb5 pointsBadges:

How to insert an image file into an Oracle 8i database

How do I insert a picture into an Oracle table?

Oracledatabase15 pointsBadges:

Locked objects, Stored Procedures, Triggers, etc

We have a custom migration system for Oracle Objects but it simply tries to create for replace the ojbect. Sometimes we are unable to do the create or replace because a program is running utilizing the object for someone us running a script or SQL statment utilizing the object. Is there a way to...

OUTDATED0 pointsBadges:

oracle explain plan from yesterday

Is it possible to see the explain plan used by Oracle for a select statement that was run yesterday?

Nightoracle5 pointsBadges:

Calculation in Oracle 10g

I have created Stud_Transaction table. The code is create table Stud_Transaction ( Student_Id varchar2(10), Account_no varchar2(20), date_of_deposit date, month varchar2(10), year number, Amount_deposited number, Stud_Acc_Balance number, CONSTRAINT fk_PerStud_Transaction FOREIGN KEY (Student_Id)...

Sivam5 pointsBadges:

Create date as column name in Oracle SQL?

I WANT TO CREATE A TABLE WITH THE COLUMN NAME AS DATE BUT IT SHOWING THE ERROR.BUT I WANT TO DISPLAY COLUMN NAME AS DATE ONLY CAN ANY ONE HELP i try it SQL> create create table store_information(store_name varchar2(10),sales varchar2(10),date date); create create table...

Rajpavan5425 pointsBadges:

Display GIS maps on Oracle forms

I want to integrate the oracle form with GIS aplications. how can i do can u please help me on this

Hadgilkar25 pointsBadges:

COmplex update takes a 90 minutes to run in Oracle

In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table has 40 records. It has been written by someone else, I don't have access to Oracle so can't check my thinking, but I believe, if we select the data to be updated into pl/sql tables,...

Abhigreen10 pointsBadges: