-
ORA-24314: service handle not initialized
I am getting the error
ORA-24314: service handle not initialized
While i login...
Please can u list the possible cause/causes?
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Re: ORA-24314: service handle not initialized
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.
Export ORACLE_SID=DBNAME or DBSID
then try.
More details would be appreciated.....
Amar
"There is a difference between knowing the path and walking the path."
-
Check this on Metalink..
Doc ID: 152474.1
Doc ID: 157428.1
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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,
-
Originally posted by SANJAY_G
Check this on Metalink..
Doc ID: 152474.1
Doc ID: 157428.1
Sanjay:
Could u please copy paste the doc here as i think i dont have acces to the oracle metalink.
Regards
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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,
I dont think there any problem in conectivity.....
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)
)
)
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by SANJAY_G
Check this on Metalink..
Doc ID: 152474.1
Doc ID: 157428.1
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......
am able to login now.....
thanks
Abhay
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|