Summary of various problems encountered after oracle installation is complete.

Summary of various problems encountered after oracle installation is complete.

Basic commands:

Logon command

Sqlplus

Sqlplus User Name

Sqlplus user name/Password

Sqlplus/nolog

-- Account connection command

Conn

Conn User Name

Conn username/password

-- Exit the system

Exit

Quit

-- View the user name and status (executed by the Administrator)

Select username, account_status from dba_users;

Default User:

Scott password is tiger

Sys password is change_on_install

The system password is manager.

The sysman password is oem_temp.

Error Type:

Scott or system password cannot be logged on (ORA-01017: invalid username/password; logon denied ):

Win + r, enter sqlplus/nolog (no user logon)

Conn/as sysdba (note the space and semicolon)

Alter user scott identified by tiger;

Account locked (ORA-28000: the account is locked ):

Unlock user: alter user scott account unlock;

Lock user: alter user scott account lock;

Service not enabled (ORA-12560: TNS: protocol adapter error ):

Right-click my computer --> Manage --> services and applications --> services --> Find OracleServiceORCL and OracleOraDb11g_home1TNSListener

Note: Determine TNSListener. The names of different versions are different.

Insufficient permissions (ORA-01031: insufficient privileges ):

Right-click my computer --> Manage --> local users and groups --> group --> Find ora_dba --> right-click Properties --> Add your current user --> Application

Enter the user of the current operating system. If you do not know the user name, you can go to: local user and group --> user to view the user name.

Generally, there are administrator, defaultXXX, Guest, and users you have created. It is very likely that you are currently using a user created by yourself. However, only administrator members are added to oracle by default.

Connection timeout (ORA-12170: TNS: Connection timeout ):

When a remote connection occurs, the firewall does not enable port 1521 (the default oracle port.

Identity Authentication retrieval failed (ora-12638 Identity Authentication retrieval failed ):

Start> program> Oracle> Configuration and Migration Tools>

Net Manager → local → profile → Oracle Advanced Security → verification → remove the "CNT" in the selected method ".