-
How to access the database with SQL PLUS?
almost 9 years ago
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 :
- User name: scott, Password: tiger
- User name: scott, Password: scott
- User name: root, Password: root
- User name: root, Password: 123456
![](javascript:showImageData("https://findnerd.s3.amazonaws.com/imagedata/4068/240x160/4068.png","blog8") "Click to preview"){kind=small}
-
almost 9 years ago
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???
-
-
almost 9 years ago
You are getting ORA-12560: TNS:protocol adaptor error becuase of the following:
- Oracle_Sid is not property set(especially on windows), it is in manual mode
- Database services is not started
Solution to this:
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.
To start Database services. Go to Start>Run> type "services.msc". Select the OracleServiceXE name, Right Click and Start.
-
2 Answer(s)