Home » Infrastructure » Linux » oracle 10g - error ora-12514
oracle 10g - error ora-12514 [message #116924] Sat, 23 April 2005 08:37 Go to next message
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 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: can't install on FedraCore3, warning :Cannot convert string...
Next Topic: Kernel compilation errors!!
Goto Forum:
  


Current Time: Fri Mar 29 07:20:37 CDT 2024