Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to access the database with SQL PLUS?

    • 0
    • 0
    • 0
    • 2
    • 0
    • 1
    • 0
    • 941
    Answer it

    Hello all, I am unable to access my SQL database as I forgot the login details. I have tried with some but getting error "ORA -12560: TNS : protocol adapter error."

    Kindly suggest me the way to retrieve the details. Is there any command to retrieve the credentials for the same??

     

     

    Some of the details I have tried but none was successful :

    1. User name:  scott, Password: tiger
    2. User name:  scott, Password: scott
    3. User name:  root, Password: root
    4. User name:  root, Password: 123456
    How to access the database with SQL PLUS?

 2 Answer(s)

  • Thank you for your response.... But I have already done this and my database is working fine all the entries are inserted through it.. but my query is am not able to open database application window.... in case if want to view the list of tables and the entries to it in my database. how can i do so??? I have actually forgot the login details of my database.... can you help me to get that back???

  • You are getting ORA-12560: TNS:protocol adaptor error becuase of the following:

    1. Oracle_Sid is not property set(especially on windows), it is in manual mode
    2. Database services is not started

    Solution to this:

    1. To set Oracle_Sid in automatic mode. Go to Start>Run> type "services.msc". Select OracleServiceORCL(or OracleServiceSID), double click and change startup to Automatic.

    2. To start Database services. Go to Start>Run> type "services.msc". Select the OracleServiceXE name, Right Click and Start.

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: