Re: SQL*NET: a server serves multiple ORACLE_HOME/ORACLE_SID?

In article cjackso_at_uswnvg.com (Clay Jackson) writes:
|> If you want to get REALLY wierd, it is possible to run more than one
|> version of the RDBMS (actually, it's not the kernel that gets you, it's
|> the versions of the SQL*NET drivers that are linked with the kernel, but
|> you should get the idea). Here's what you need to do (all of this
|> assumes you're on a Unix box):
|> 1) In /etc/services, you'll find a line that looks something like
|> orasrv 1525/tcp tcp # oracle
|> This specifies the PORT number that orasrv is going to use.
|> Add another line with a new port number, ala:
|> mysrv 1526/tcp tcp # new server
|> You may also have to hack your tcp startup files to enable
|> this port, and your (Unix) kernel to support it.
|> 2) Start a the second listener, from the Unix command line, like
|> so (note, this only works if you're using the TLI based
|> server products - the command will probably be a bit
|> different for socket based tcp):
|> TLI_SERVER=mysrv; export TLI_SERVER
|> tcptlictl start
|> This will start a second listener, on the port you specified
|> above.
|> 3) To connect to the second listener, put the name of the server
|> in the connect string, like so:
|> connect scott/tiger_at_T:<hostname>,mysrv:<sid>
|> If you're unsure about any of this, you may want to contact Oracle
|> Support and/or your SysAdmins for further assistance. As always, your
|> mileage may vary.

I just wanted to add that this method is only necessary under certain Unix platforms running two different versions of the Oracle database. In most cases, however, only one orasrv process is required to listen for all instances of Oracle regardless of version number. A specific example is a Sun Sparc where I have the latest orasrv listener up for both a 6.0.36 and a 7.0.12 instance of Oracle.

Roderick Manalac
Oracle Corporation
Worldwide Support
[Disclaimer: My opinions are my own, right dear?] Received on Tue Feb 16 1993 - 05:30:31 CET