| ora -12514 [message #53197] |
Mon, 02 September 2002 14:22  |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Hi ,i have next problem:
I Have this in TNSNAMES.ORA :
PRUEBA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prueba)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
In LISTENER.ORA :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:Oracleora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = prueba)
(ORACLE_HOME = C:Oracleora81)
(SID_NAME = prueba)
)
)
And INIT.ORA:
db_name = prueba
instance_name = prueba
service_names = prueba
When i try to connect i have the error:
ORA-12514: TNS:Listener could not resolve SERVICE-NAME given in connect descriptor.
I donīt Know what is the problem.Please help!!
thanks in advance.
|
|
|
|
| Re: ora -12514 [message #53211 is a reply to message #53197] |
Tue, 03 September 2002 14:30  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Why you have HOST=localhost? Try using the IP address or domain name instead. Also you are trying to connect locally to the only one db instance on the box. You can just do : sqlplus user/name.
What is your Oracle version? Try using SID instead SERVICE_NAME in tnanames.ora. Also do you have SQLNET.DEFAULT_DOMAIN=.... in your sqlnet.ora file? If so it has to be added after the TNS alias in your tnsnames.ora file as well.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
