Home » RDBMS Server » Security » OID issue (Oracle 10.2.0.3 on AIX)
OID issue [message #360073] Wed, 19 November 2008 07:56 Go to next message
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 #360140 is a reply to message #360073] Wed, 19 November 2008 14:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


1/ check listener status
2/ check your network if any problem

Babu
Re: OID issue [message #360326 is a reply to message #360140] Thu, 20 November 2008 07:29 Go to previous message
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
Previous Topic: How to log program and module used by any session
Next Topic: use aud$ table
Goto Forum:
  


Current Time: Thu Mar 28 15:43:54 CDT 2024