ORA-12514 when trying to connect to new db
Hello,
I just made a fresh installation of Oracle 11gR2 on x64 RHEL6 Linux. When I'm trying to connect to db from client, I always get an error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
Seems to be I have wrong listener's service name on server, looks like "name.domain.com" instead of just "name", how could I change it ?
Here is my:
- client's tnsnames.ora:
ORA11R2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = ORA11R2)))
- server's listener.ora:
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora11g.my.domain.com)(PORT = 1521))))
ADR_BASE_LISTENER = /u01/app/oracle
$lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 13-FEB-2013 16:15:54
...
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g.my.domain.com)(PORT=1521)))
Services Summary...
Service "ora11r2.my.domain.com" has 1 instance(s).
Instance "ora11r2", status READY, has 1 handler(s) for this service...
Service "ora11r2XDB.my.domain.com" has 1 instance(s).
Instance "ora11r2", status READY, has 1 handler(s) for this service...
Edited by: 964323 on 13.2.2013 6:24