969352 wrote:edit file /u01/app/oracle/product/10.2.0/db_1/network/log/listener_orcl.log
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
$ sqlplus /nologThis is another database >>
969352 wrote:just FYI - no remote client can ever connect to DB Server using 127.0.0.1
*$ uname -a*
Linux linuxserver 2.6.9-126.96.36.199.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 athlon i386 GNU/Linux
*[oracle@linuxserver ~]$ cat /etc/hosts*
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 linuxserver localhost.localdomain localhost
969352 wrote:For now, there is no need to change /etc/host file. It can only be done by OS root user.
just FYI - no remote client can ever connect to DB Server using 127.0.0.1
I did n't set ip in /etc/hosts file.
Can i update ip address in that file ?
- I am very sorry for disturbing sb AS per your suggestion i changed both name as MYDB.TEST.ORCLTEST.COM ( listener.ora ,tnsnames.ora)It bothers me that the tnsnames.ora file specifies SERVICE_NAME while listener.ora specifies SID.
IMO, both should use the same; either both use SID or both use SERVICE_NAM