Hi,
Environment
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
I'm getting ORA-28547: connection to server failed, probable Oracle Net admin error while connecting to the database like username/password@orcl,If i'm not using @orcl it's connecting without any issue .But without dbstring i cannot connect from the client machines.
This problem started recently and i understand it is because of the dynamic ip of the linux machine.Previously the Linux m/c ip was 172.25.210.177 unfortunately it was shutdown once started the machine ip got changed to 172.25.210.148.
To bring back the database up i was started as usually and db got up but while connecting with username/password@orcl the above error is occurring.
To resolve the i've changed ip address in tnsnames.ora and listener.ora but no luck.Please advice how to resolve.