Accessing 2 databases (10g) on Win XP Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Accessing 2 databases (10g) on Win XP

  1. #1
    Join Date
    Mar 2006

    Accessing 2 databases (10g) on Win XP


    Have created 2 databases with Oracle 10g on a single PC. The fist at install, the second later with Database Assistant.

    Enterprise manager (also called Database Control) is always accessing the first one, even ORACLE_SID is set to the second one in registry.

    Have I to type another address than http://localhost:1158/em to access the second database ?

    Thanks in advance for reply.

  2. #2
    Join Date
    Mar 2006
    Charlotte, NC
    Check %ORACLE_HOME%\install\portlist.ini

    That file will tell you which port number is using for which instance.

  3. #3
    Join Date
    Mar 2006

    Otherwise, I found in the browser the following address filled in the address bar :

    http:// localhost:1158/em/console/database/instance/sitemap?event=doLoad&target=base1&type=oracle_database

    So I have created a copy of the link for OEM, put this url in the "URL" field on the link, changed "base1" to "base2", and I get a correct link to open OEM for "base2".

    Starting and shutdowning the correct database (or both) may be done with SQL*Plus, connect sys/psw@base1 (or 2) as sysdba, then startup or shutdown.

    Thanks again and good evening.

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