one listener multiple database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: one listener multiple database

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    172
    Hi everyone,

    I have two versions 8.0.6 and 8.1.7 on one unix machine. At startup the 8.0.6 listener starts and the only way i can get the 8.1.7 listener to start is lsnrctl stop and lsnrctl start, which starts the 8.1.7 listener. How can I configure only the 8.1.7 listener to listen for both db's and auto start on startup?

    Thanks in advance,
    kathy

  2. #2
    Join Date
    Feb 2001
    Posts
    66
    just start only 8.1.7. listener,
    and the second database can be configured on the SID description of the listener.ora file:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\home for 8.1.7)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = db_8.1.7)
    (ORACLE_HOME = D:\home_8.1.7)
    (SID_NAME = sid_8.1.7)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = db_8.6)
    (ORACLE_HOME = D:\home_8.6)
    (SID_NAME = sid_8.6)
    )
    )

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    relevant thread for your Q

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=6378[/url]
    Reddy,Sam

  4. #4
    Join Date
    Nov 2000
    Posts
    172
    thank you for the helpful information, but can you explain what the

    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\home for 8.1.7)
    (PROGRAM = extproc)

    PLSExtProc and extproc represents.

    And where can I find my global db_name, I dont' have a services_name parameter in my init file?
    Thanks



  5. #5
    Join Date
    Feb 2001
    Posts
    66
    If you don't need, you don't have to use this block:
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\home for 8.1.7)
    (PROGRAM = extproc)

    This is only for external procedures, I guess, when you have to call external procedures.

    And db_name must be on the top of your init.ora file

  6. #6
    Join Date
    Nov 2000
    Posts
    172
    Great, I got two services from my 8.1.7 listener, one for each db. Thanks

    Now, I am still having a problem because when I reboot the server the 8.0.6 listener gets started automatically. I need the 8.1.7 listener to start on reboot.

    I can start the 8.1.7 manually lsnrctl stop, lsnrctl start. But I need it to start on startup. I can't find the file that tells the listener to start? Any ideas?

    Thanks

  7. #7
    Join Date
    Feb 2001
    Posts
    66
    maybe LSNRCTL> SET current_listener ?
    after starting the right one

  8. #8
    Join Date
    Feb 2001
    Posts
    2

    Wink

    did u put the dbstart file path in the rc2.d directory....? in the same file mention the path of the listenere and mention start...it will start up....or mail me i will give u the complete script....word by word...good luck....sethijagdeep@usa.net....

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What OS ?If its Unix What Shell you are using ?

    C Shell:

    Go to Profile of Oracle userid thats .cshrc and make an entry like this
    And/OR
    at the end of Oracle provided file "/usr/bin/coraenv" under local modifications

    setenv TNS_ADMIN=/O_H_817/network/admin

    K Shell:

    Go to Profile of Oracle userid thats .cshrc and make an entry like this
    And/OR
    at the end of Oracle provided file "/usr/bin/oraenv" under local modifications

    set TNS_ADMIN=/O_H_817/network/admin

    Rename(prefix) Oracle 806 binaries to say .old

    lsnrctl as lsnrctl.old so that it never gets invoked and always 817 binaries will be invoked.
    Reddy,Sam

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