Not logging in to sql+
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Not logging in to sql+

  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unhappy Not logging in to sql+

    Hi this is durgaprasad trainee in a company,as that i installed oracle software at the time of installation i unlocked scott,after completion of installation it asking username,password and host string,i entered scott as username and tiger as password and host string i didnt give anything.its not logging, th roughing error tnsrotocol adapter error.what i have to do?is there any way?plz suggest .
    Thank you

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Your environment is not setup correctly. Is this Windows, Linux, Unix, MS DOS 5.0? It would help to know what you are dealing with. You should probably look up how to create a listener for your OS, learn how to setup the environment variables for you OS. You will need environment variables for ORACLE_HOME, LD_LIBRARY_PATH, add $ORACLE_HOME/bin or %ORACLE_HOME%\bin to your PATH statement and finally ORACLE_SID. If you are using Linux/Unix there should be an oraenv script in /usr/local/bin, hence:

    . oraenv
    db name

    Keep looking you will get the answer.
    this space intentionally left blank

  3. #3
    Join Date
    Mar 2001
    Location
    India
    Posts
    58
    Hi,

    Set proper Oracle Home, PATH and Oracle SID variables. If you are on Windows then check service of Oracle database needs to be started.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

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