In sqlplus I type show parameter name and I get the following output
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string orcl
db_unique_name string orcl
global_names boolean FALSE
instance_name string orcl
lock_name_space string
log_file_name_convert string
service_names string EXP
SQL>
However, when I try to connect from a client PC like this
sqlplus system/password@DBHOST/EXP
I cannot connect - I get the error:
ORA-12514: TNS:listener does not currently know of service requested in connect
On the host, I type lsnrctl status and I get this for the listening end points:
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OracleExp)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "EXP.168.203.30" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl.168.203.30" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.168.203.30" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
I can connect from a client pc as long as I use the suffix .168.203.30 - in other words
sqlplus system/password@oracleexp/exp.168.203.30
works fine. However, I don't want to use the suffix!
Why is the listener appending a suffix to my service name and how can I stop it doing that?
Thanks
A.