Log on problem, two Oracle Directories present on the same server

[Former Member]

Hi Gurus,

I am installing SAP 4.7 oracle 9i, on the server which had already installed ECC6, Database Oracle 10g.

Now i install oracle 9i working fine. sqlplus logon ok.

But i want to log on to oracle 10 by sqlplus how could I work on both oracle 9i & oracle 10g.

when I run the commond sqlplus /nolog it goes to oracle 9i default.

Regards,

Darshan...

[Former Member]

Hii,

Problem is solved by changing System variable Path with old Oracle HOME Directory 10g.

Regards,

Darshan...

[former_member682089]

Hello Darshan,

Please do the following steps:-

1.run the cmd command.

2. set ORACLE_SID= to SID og 10g.

3.check ORACLE_HOME

4. Run sqlplus "/as sysdba"

Regards,

Sandeep Nayak

[Former Member]

Hi Darshan,

Ensure that you have define the enviroment variable and path for every sidadm users.

Do not define the enviroment variables and path for system.

[markus_doehr2]

> I am installing SAP 4.7 oracle 9i, on the server which had already installed ECC6, Database Oracle 10g.

>

> Now i install oracle 9i working fine. sqlplus logon ok.

> But i want to log on to oracle 10 by sqlplus how could I work on both oracle 9i & oracle 10g.

> when I run the commond sqlplus /nolog it goes to oracle 9i default.

you have to make sure you use the correct user and the correct ORACLE_HOME.

Markus

[Former Member]

yes I am using correct user, whats about Oracle_home.

as before installing 9i it was same in this user variable.

Regards,

Darshan..

[markus_doehr2]

Usually you would have two different users, one for the 4.7 instances and Oracle 9.2 and one for the other.

If the system was set up correctly the ORACLE_HOME will point to the correct locations.

Markus

[Former Member]

Hi,

yes I am using different user for 9i & 10g.

as I am loged in <SID>adm & default seting of Oracle_Home in ECC60 on 10g is D:\oracle\ECD\102\bin

For 9i user <SID>adm & Oracle_home in SAP4.7 F:\oracle329\DEV\902

Regards,

Darshan..

[markus_doehr2]

It shouldn't be necessary to set that explicitly.

try the following:

- logon as first user (Oracle 9.2)

- open a cmd.exe

- execute "echo %ORACLE_HOME%

- execute "echo %ORACLE_SID%

Then do the same for the other user. If they do not match then there went something wrong during the installation.

Markus

[former_member105207]

hi,

as I am loged in <SID>adm & default seting of Oracle_Home in ECC60 on 10g is D:\oracle\ECD\102\bin

check ur oracle home in ECC 6.0

it should be D:\oracle\ECD\102

regards

chandru