Q
Problem solve Get help with specific problems with your technologies, process and projects.

Username and password not working

I installed Oracle 9i, but when I tried to log in in SQL, it asked for username and password. I provided system and manager but it did not work. I used scott and tiger as username and password but could not be validated, and at last I uninstalled Oracle 9i and installed 8i, but had the same problem again.

I installed Oracle 9i on a computer with Windows 2000 Professional and SP4, but after completeting the installation, when I tried to log in in SQL, it asked for username and password. I provided system and manager but it did not work. I used scott and tiger as username and password respectively but could not be validated, and at last I uninstalled Oracle 9i and installed 8i, but had the same problem again. Can you please tell me its solution?

Because you have not provided me with exact error messages, it's difficult for me to determine what the problem is. If you are trying to connect via SQL*Plus on the database server or from another remote machine, the Oracle listener must first be started.

The Oracle database listener can be started either from the command prompt or from the Services panel. To start the listener from the command prompt, type:

C:>lsnrctl start
To determine the status of the listener from the command prompt, type:
C:>lsnrctl status
You can also start the listener from the Services panel. Look for a service called OracleOraDb10g_homeTNSListener (or something similar to this), right-click on the service and choose 'Start.'

It is also possible that you are providing incorrect passwords for both the SYSTEM and SCOTT accounts.

Dig Deeper on Oracle database installation, upgrades and patches

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close