- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Serviceguard & oracle listener
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 12:24 AM
тАО04-09-2002 12:24 AM
Serviceguard & oracle listener
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 ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 12:29 AM
тАО04-09-2002 12:29 AM
Re: Serviceguard & oracle listener
can you post copies of your listener.ora from your server, and tnsnames.ora from your client?
Thanks
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 12:41 AM
тАО04-09-2002 12:41 AM
Re: Serviceguard & oracle listener
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
. /home/oracle/.profile
export ORACLE_SID=
svrmgrl <
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 01:01 AM
тАО04-09-2002 01:01 AM
Re: Serviceguard & oracle listener
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)
)
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 01:16 AM
тАО04-09-2002 01:16 AM
Re: Serviceguard & oracle listener
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2002 02:34 AM
тАО04-09-2002 02:34 AM
Re: Serviceguard & oracle listener
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