| oracle 10g - error ora-12514 [message #116924] |
Sat, 23 April 2005 08:37  |
kajko
Messages: 1
Registered: April 2005
|
Junior Member |
|
|
Hi.
I am new with oracle, but I want to set a 10g on the Linux.
I finish installation, and I set a database with Sid nms.
I setup a client computer and everything working fine until I first time reboot the server. After that I lost connection to the database.
I found that I have to use LSNRCTL to start service:
LSNRCTL> start listener
Starting /home/oracle/10g/OracleHome/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.3.0 - Production
System parameter file is /home/oracle/10g/OracleHome/network/admin/listener.ora
Log messages written to /home/oracle/10g/OracleHome/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date 23-APR-2005 08:24:17
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/10g/OracleHome/network/admin/listener.ora
Listener Log File /home/oracle/10g/OracleHome/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL>
oracle@nms:~$ tnsping nms
TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 23-APR-2005 08:25:04
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
/home/oracle/10g/OracleHome/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 209.110.76.50)(PORT = 1521))) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = nms)))
OK (0 msec)
oracle@nms:~$
When I try connect to the server :
oracle@nms:~$ sqlplus kajko@nms
SQL*Plus: Release 10.1.0.3.0 - Production on Sat Apr 23 08:25:44 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
My listener.ora and tnsname.ora:
# Generated by Oracle configuration tools.
SID_LIST_NMS_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = nms)
(ORACLE_HOME = /home/oracle/10g/OracleHome)
(SID_NAME = nms)
)
)
NMS_LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nms)(PORT = 1521))
)
# tnsnames.ora Network Configuration File: /home/oracle/10g/OracleHome/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
NMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 209.110.76.50)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nms)
)
)
Can you help me solve this problem?
Why just after installation everything is fine but after reboot the server I have problems?
How I can setup to auto run the database, after reboot the system?
Thank you for help
|
|
|
|
| Re: oracle 10g - error ora-12514 [message #117823 is a reply to message #116924] |
Fri, 29 April 2005 16:22  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Shutdown the listener called LISTENER, start NMS_LISTENER (as configured in your listener.ora), and try to connect again:
$ lsnrctl stop listener
$ lsnrctl start nms_listener
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
