-
Oracle hangs after entering userid/pwd@conn
Hi All,
I have a server which has 2 oracle9i instances and running .
In one instance when i give the userid/pwd@connection it is not logging in.
$ sqlplus userid/pwd@hostdtring
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 5 07:16:26 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
it is in hang state and not proceeding after the above message.
have anyone faced this time of errors.
-
Are you attempting to log into the Oracle instance on the box of from a remote station?
Have you set your environmental variables correctly?
Did it work before and stopped working now... or it never worked?
Just to be sure, how many Oracle codesets/oracle_home do you have in the box?
Can you connect as follows: sqlplus /nolog after setting proper environmental variables?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Hi PAVB,
Thanks for your quick response
It was working before and now suddenly we are facing this problem
I set the environment varaiable for ORACLE_SID
then did sqlplus /nolog
the connected as sys dba and connected
ican see the username which i need to connect in the dba_users
But when i try to conenct using the required username it hangs
Last edited by Tarus; 03-05-2009 at 09:13 AM.
-
What happens is you set your ORACLE_SID and then do sqlplus userid/password ?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
$ sqlplus userid/pwd@hoststring
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 5 09:38:13 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
......hangs from hereeeee
-
Originally Posted by Tarus
$ sqlplus userid/pwd@hoststring
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 5 09:38:13 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
......hangs from hereeeee
This is not the test I asked for... take out "@hoststring" and try again.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Hi
$ sqlplus userid/pwd
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Mar 5 10:28:04 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
-----hangs hereeeee
-
export ORACLE_SID...
sqplus /nolog
conn userid
pwd
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
export ORACLE_SID --done
sqlplus /nolog
conn userid
enter password: entered password
-----hangs here
-
Does it happens only with this specific account or it happens with all non DBA accounts?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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
|