Oracle initial login

A bunch of problems after installation. The first step is that the logon fails and the password and user name are unknown.

 

So I used database configuration and migration tools to create a database demo. At the time of creation, I gave AAA passwords to SYS, system, Dbsnmp, sysman, and other users.

However, after logging on, you will find that the demo tables DEPT and EMP are missing. Therefore, you have to use the default orcl database for installation.

 

Then, the demo database is deleted using database configuration and migration tools. When I log on with sqlplus, I do not report a Password error or a protocol adapter error. Check the Internet:

 

Solution to ORA-12560: TNS: protocol adapter errors

There are three reasons for the problem that caused the ORA-12560: TNS: protocol adapter error:

1. The listening service is not started. On the Windows platform, perform the following operations: start --- program --- management tools --- Service, open the service panel, and start the oracleoradb11g_home1tnslistener service.

2. The database instance is not started. On Windows, perform the following operations: start --- program --- management tools --- Service, open the service panel, start oracleservicexxxx, XXXX is your database Sid, and oracleserviceorcl is my service.

3. Registry issues. Regedit, and enter HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ home0 to set the environment variable oracle_sid to xxxx. XXXX is your database Sid. or on the right, my computer, property -- Advanced -- environment variable -- System variable -- New, variable name = oracle_sid, variable value = XXXX, XXXX is your database Sid. or, before entering sqlplus, enter SET oracle_sid = XXXX under command line, and XXXX is your database Sid.
Here, the value is "Demo" instead of "orcl. So if it is changed to orcl, it will be OK. At least the protocol error will not be reported, but the password will be incorrect.

 

 

 

Certificate --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

This is the battle with the Oracle initial password:

 

The problem is:

I log on to SYS, use change_on_install as the password, and report invalid username/password: Login denied.

I log on to Scott and use tiger as the password to report that the user has been locked.

 

Check online:

You can log on to the local machine as follows: sqlplus/As sysdba

Then you can change the Sys password,

You can also unlock Scott users.

Alter user SYS identified by newpass; (in my own practice, if this item fails, "the option is missing or invalid" is reported ")

Alter user Scott account unlock;

 

I tried it.

The second one is successful. Log on again and say that Scott's original password has expired. Let me set a new password and I set tiger.

 

Log on and use select * from Dept. This table already exists.