Serviceguard & oracle listener

[Martin Young]

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 ...

[Duncan Edmonstone]

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

[Printaporn_1]

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.

[Martin Young]

# 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]

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.

[Steven Gillard_2]

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