| sqlplus [message #52321] |
Mon, 15 July 2002 08:41  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
bash-2.05a$ sqlplus
scott/manager@Frankinstain.Frankinstain
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jul 15
09:23:41 2002
(c) Copyright 1999 Oracle Corporation. All rights
reserved.
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME
given in connect
descriptor
can anyone tell me what im doing wrong?
|
|
|
|
|
|
| Re: sqlplus [message #52325 is a reply to message #52321] |
Mon, 15 July 2002 12:08  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
bash-2.05a$ sqlplus scott/manager@Frankinstain
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Jul
15 12:53:01 2002
(c) Copyright 1999 Oracle Corporation. All rights
reserved.
ERROR:
ORA-12154: TNS:could not resolve service name
it geavs just another error
|
|
|
|
| example [message #52340 is a reply to message #52321] |
Tue, 16 July 2002 13:13 |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
oracle@Frankinstain:/u01/app/oracle/product/8.1.6/bin$
lsnrctl start frank
LSNRCTL for Linux: Version 8.1.6.0.0 - Production on
16-JUL-2002 13:54:02
(c) Copyright 1998, 1999, Oracle Corporation. All
rights reserved.
Starting /u01/app/oracle/product/8.1.6//bin/tnslsnr:
please wait...
TNSLSNR for Linux: Version 8.1.6.0.0 - Production
System parameter file is
/u01/app/oracle/product/8.1.6/network/admin/listener.ora
Log messages written to
/u01/app/oracle/product/8.1.6/network/log/frank.log
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Frankinstain.Frankinstain)(PORT=1521)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Frankinstain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias frank
Version TNSLSNR for Linux: Version
8.1.6.0.0 - Production
Start Date 16-JUL-2002 13:54:02
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/8.1.6/network/admin/listener.ora
Listener Log File
/u01/app/oracle/product/8.1.6/network/log/frank.log
The listener supports no services
The command completed successfully
oracle@Frankinstain:/u01/app/oracle/product/8.1.6/bin$
----------
oracle@Frankinstain:/u01/app/oracle/product/8.1.6/bin$
sqlplus scott/manager@frank.Frankinstain
SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jul
16 13:55:34 2002
(c) Copyright 1999 Oracle Corporation. All rights
reserved.
ERROR:
ORA-12514: TNS:listener could not resolve
SERVICE_NAME given in connect
descriptor
----------
and will geave you listener.ora and tnsnames.ora
# LISTENER.ORA Configuration
File:/u01/app/oracle/product/8.1.6//network/admin/listener.ora
# Generated by Oracle configuration tools.
FRANK =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Frankinstain)(PORT = 1521))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Frankinstain)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST =
Frankinstain)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6)
(PROGRAM = extproc)
)
)
---------------
# TNSNAMES.ORA Configuration
File:/u01/app/oracle/product/8.1.6//network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA.FRANKINSTAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
FRANK.FRANKINSTAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
Frankinstain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = frank)
)
)
thanks for your help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
