how to access another instance at the unix box with prod database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to access another instance at the unix box with prod database

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    how to access another instance at the unix box with prod database

    There is another instance on the same unix box as production database. But everytime I invoke sqlplus, it goes to production database. How could I get into the other instance? I tried: set ORACLE_SID=myinstance and export ORACLE_SID myinstance then invoke sqlplus. It didn't work.

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,003
    Is TWO_TASK set? Are they both using the same Oracle Home?

    How about connect system/manager@theotherdb?
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width