Skip to Content
author's profile photo Former Member
Former Member

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

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...

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Aug 07, 2008 at 10:50 AM

    > 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 11:58 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 08, 2008 at 08:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2008 at 12:05 PM

    Hii,

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

    Regards,

    Darshan...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.