SQL> ALTER DATABASE OPEN;
Thanks very much - I spent ages trying to fix this 'till I saw your post.AlanK
Alan, you are always welcome..
Hi Mr. Borulia, In my system also showing same error and but when i open /etc/hosts file it's showing like those lines, are they correct220.127.116.11 DBA1 # Added by NetworkManager127.0.0.1 localhost.localdomain localhost::1 DBA1 localhost6.localdomain6 localhost6192.168.23.151 DBA #other hostname192.168.23.149 DBA2 #one more hostname
can you please paste here your hosts ?
Your host file need to be:127.0.0.1 localhost.localdomain localhost . Pay attention, 127.0.0.1 localhost.localdomain localhost need to be first line.
actual my real host is DBA1 and remaining hosts are other o/s hosts
You need to change your /etc/hosts files to be :127.0.0.1 localhost.localdomain localhostserver_ip dba1.your_domain dba1127.0.0.1 localhost.localdomain localhost need to be the first line
please give me as clearly and then when iam going for tnsping command, it's also gettin error[oracle11g@DBA2 ~]$ tnsping lsnrTNS Ping Utility for Linux: Version 18.104.22.168.0 - Production on 30-JUL-2014 23:44:42Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:TNS-03505: Failed to resolve name
Confirm sid=xxxxx for both listener.ora and tnsnames.ora