Oracle hangs after entering userid/pwd@conn
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Oracle hangs after entering userid/pwd@conn

  1. #1
    Join Date
    Jan 2009
    Posts
    10

    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.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Jan 2009
    Posts
    10
    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.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  5. #5
    Join Date
    Jan 2009
    Posts
    10
    $ 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

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Tarus View Post
    $ 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.

  7. #7
    Join Date
    Jan 2009
    Posts
    10
    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

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  9. #9
    Join Date
    Jan 2009
    Posts
    10
    export ORACLE_SID --done

    sqlplus /nolog

    conn userid
    enter password: entered password
    -----hangs here

  10. #10
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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
  •  


Click Here to Expand Forum to Full Width