I am getting the error
ORA-24314: service handle not initialized
While i login...
Please can u list the possible cause/causes?
Abhay.
Printable View
I am getting the error
ORA-24314: service handle not initialized
While i login...
Please can u list the possible cause/causes?
Abhay.
Export ORACLE_SID=DBNAME or DBSIDQuote:
Originally posted by abhaysk
I am getting the error
ORA-24314: service handle not initialized
While i login...
Please can u list the possible cause/causes?
Abhay.
then try.
More details would be appreciated.....
Check this on Metalink..
Doc ID: 152474.1
Doc ID: 157428.1
Seems there is a problem with your connection
Check your sid_name in the listener.ora file
and the service_name in tnsnames.ora
Regards,
Sanjay:Quote:
Originally posted by SANJAY_G
Check this on Metalink..
Doc ID: 152474.1
Doc ID: 157428.1
Could u please copy paste the doc here as i think i dont have acces to the oracle metalink.
Regards
Abhay.
I dont think there any problem in conectivity.....Quote:
Originally posted by sursujmad
Seems there is a problem with your connection
Check your sid_name in the listener.ora file
and the service_name in tnsnames.ora
Regards,
check it out.
TNS Names :
TEST.Domain =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MySystem)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Test.Domian)
)
)
Listener.Ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora9i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = C:\Oracle\Ora9i)
(SID_NAME = TEST)
)
)
I som how got the docs.....n yes i suppose there were Oracle shadow processes from the dead SQL*Plus session hung which was causing this......Quote:
Originally posted by SANJAY_G
Check this on Metalink..
Doc ID: 152474.1
Doc ID: 157428.1
am able to login now.....
thanks
Abhay