Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Serviceguard & oracle listener

Martin Young
Occasional Contributor

Serviceguard & oracle listener

I have a serviceguard package with ip address 50.120.1.129. This runs on a server with host address 50.120.1.76. Oracle 8.1.6 is installed on the package, but I'm having problems configuring the listener. When I use the host address (ie .76) in the listener.ora and tnsnames.ora config files I can connect remotely to the database.
However I want to use the package ip address to cope with failover; when I change the config files to use the .129 address and try to connect on that address I get the following error:

09-APR-2002 08:34:06 * (CONNECT_DATA=(SID=UBRMIDP)(CID=(PROGRAM=D:\orant\jre11\b
in\java.exe)(HOST=UBRSYSDC0192)(USER=youngm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=50
.76.132.167)(PORT=1818)) * establish * UBRMIDP * 12505
TNS-12505: TNS:listener could not resolve SID given in connect descriptor

I can telnet to the package address on port 1521 OK so it's definitely listening on that address, but it doesn't seem to make the connection to the database.

The only difference I can see in the logs is when I use the machine ip address the following entry shows in the listener log on database startup

09-APR-2002 08:27:36 * service_register * UBRMIDP * 0

When I change to the package ip address and stop and start everything this message does not appear.

Help!! I'm sure somebody has come across this before ...
5 REPLIES
Duncan Edmonstone
Honored Contributor

Re: Serviceguard & oracle listener

Does tnsping from the client work?

can you post copies of your listener.ora from your server, and tnsnames.ora from your client?

Thanks

Duncan


HTH

Duncan
Printaporn_1
Esteemed Contributor

Re: Serviceguard & oracle listener

Hi Martin,

I wonder why not just start listener as part of package.
this is what I simply do :

- in package control script
function customer_defined_run_cmds
{
# ADD customer defined run commands.

//}

and in that #!/usr/bin/sh
. /home/oracle/.profile
export ORACLE_SID=
svrmgrl <connect internal
startup;
exit;
EOF
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/lsnrctl dbsnmp_start

OR

automatic start listener at both node at port 1521 does not matter where package running but listener always start.

donno this answer your question or not.
enjoy any little thing in my life
Martin Young
Occasional Contributor

Re: Serviceguard & oracle listener

# TNSNAMES.ORA Configuration File:/opt/oracle/product/8.1.6/network/admin/tnsnam
es.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

UBRMIDP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 50.120.1.129)(Port= 1521))
(CONNECT_DATA = (SID = UBRMIDP))
)





# LISTENER.ORA Configuration File:/opt/oracle/product/8.1.6/network/admin/listen
er.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 50.120.1.129)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 50.120.1.129)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/8.1.6)
(PROGRAM = extproc)
)
)
Justo Exposito
Esteemed Contributor

Re: Serviceguard & oracle listener

Hi Martin,

I think that printaporn is right, I have service guard and oracle in my box and the listener is part of a pakage, and all it's running fine.

Regards,

Justo.
Help is a Beatiful word
Steven Gillard_2
Honored Contributor

Re: Serviceguard & oracle listener

Try setting the init.ora parameter local_listener. This tells the PMON process the address of the listener that it should register with, because by default its going to try to connect to port 1521 on the local machine.

Eg in your case add this to init.ora:

local_listener=UBRMIDP

The PMON process will now use the tnsnames.ora entry for UBRMIDP for registration which specifies the correct IP address.

Regards,
Steve