Problemas al conectar
Publicado por miguel (3 intervenciones) el 14/08/2008 17:54:44
Hola, al querer conectar con la base de datos me sale este error:
'-------------------------------------------------------------
The test did not succeed.
ORA-12500: TNS:listener failed to start a dedicated server process
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
'-------------------------------------------------------------
Esta es la configuración del Listener y del TNSNAMES
'-------------------------------------------------------------
TNSNAMES:
# C:ORANTNET80ADMINTNSNAMES.ORA Configuration File:C:orant et80admin nsnames.ora
# Generated by Oracle Net8 Assistant
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
'-------------------------------------------------------------
Listener:
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= TCP)
(Host= Server)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP )
(Host= Server)
(Port= 1531)
)
)
STARTUP_WAIT_TIME_LISTENER = 10
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = 'c:orant')
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = (oracle)
'-------------------------------------------------------------
Es posible que el error esté en alguno de los archivos?
Gracias
'-------------------------------------------------------------
The test did not succeed.
ORA-12500: TNS:listener failed to start a dedicated server process
There may be an error in the fields entered
or the server may not be ready for a connection.
You can check the server and retry, or continue.
'-------------------------------------------------------------
Esta es la configuración del Listener y del TNSNAMES
'-------------------------------------------------------------
TNSNAMES:
# C:ORANTNET80ADMINTNSNAMES.ORA Configuration File:C:orant et80admin nsnames.ora
# Generated by Oracle Net8 Assistant
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
'-------------------------------------------------------------
Listener:
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= TCP)
(Host= Server)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP )
(Host= Server)
(Port= 1531)
)
)
STARTUP_WAIT_TIME_LISTENER = 10
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = 'c:orant')
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = (oracle)
'-------------------------------------------------------------
Es posible que el error esté en alguno de los archivos?
Gracias
Valora esta pregunta


0