DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2000

    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.


  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.