OID issue [message #360073] |
Wed, 19 November 2008 07:56 |
dkranes
Messages: 25 Registered: February 2008 Location: Upstate New York
|
Junior Member |
|
|
Hello fellow DBA's. I have never used OID but have been asked by one of my clients to fix an issue with OID. They apparently changed DNS for one of their database servers and can now no longer connect. TNS works fine but LDAP does not. If I do a TNSPING I get the following
$ tnsping hp123
TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production on 19-NOV-2008 09:00:17
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
/oracle10G/app/oracle/product/10.2.0/network/admin/sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=HP2)(PORT=1521)))(CONNECT_DATA=(SID=HP123)(SERVER=DEDICATED)))
TNS-12541: TNS:no listener
Can someone please explain ho i can change the alias to point to the correct DNS name? Thank you kindly in advance.
-David
[Updated on: Wed, 19 November 2008 08:46] Report message to a moderator
|
|
|
|
Re: OID issue [message #360326 is a reply to message #360140] |
Thu, 20 November 2008 07:29 |
dkranes
Messages: 25 Registered: February 2008 Location: Upstate New York
|
Junior Member |
|
|
The listener and network are fine. As soon as I modify the SQLNET.ORA to use TNSNAMES instead of LDAP it works fine. I tried logging into Net Manager using the default orcladmin username and password but I can't log in. The same username and password work fine for oidadmin. Can the servive name be modified in the oidadmin utility? The DNS name for this machine was changed and I need to update LDAP. Any help is greatly appreciated. Thank you.
-David
|
|
|