Oracle Database sysdba permission logon Problems

Welcome to the Oracle community forum and interact with 2 million technical staff. There are two ways to log on to the database using sysdba: OS authentication and password file verification; there are two login Methods: one is to log on directly to the Database Host (using OS authentication), the other is to log on remotely through the network, and the parameter to be set has two

Welcome to the Oracle community forum and interact with 2 million technical staff> there are two ways to log on to the database using sysdba for verification. One is to pass OS authentication, one method is password file authentication; the other is to log on directly to the Database Host (using OS authentication); the other is to log on remotely through the network; you need to set two parameters:

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

You can use either OS authentication or password file authentication to verify the database logon with sysdba, one is to log on directly to the Database Host (using OS authentication), and the other is to log on remotely through the network. Two parameters need to be set, one is SQLNET. AUTHENTICATION_SERVICES, one is REMOTE_LOGIN_PASSWORDFILE.

OS authentication: If OS authentication is enabled and sysdba is used for logon, you only need to install the oracle software to log on to sqlplus "/as sysdba ". If you want to disable OS authentication and only use the password file to log on, you must first have a password file:

D: \ oracle \ ora92 \ database> orapwd file = PWDoralocal. ora password = mypassword entries = 10;

D: \ oracle \ ora92 \ database>

Set $ ORACLE_HOME/network/admin/sqlnet. ora:

SQLNET. AUTHENTICATION_SERVICES = none

You must note that the password file is only loaded when the database is started. Once it is loaded, the password file is out of oracle management. Therefore, after you create a password file using orapwd, the password specified in it must be restarted before it takes effect:

D: \ oracle \ ora92 \ database> sqlplus "sys/mypassword as sysdba"

SQL * Plus: Release 9.2.0.1.0-Production on Fri May 16 21:59:42 2008

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus

### Here we use OS authentication to log on to the database by modifying SQLNET. AUTHENTICATION_SERVICES = (ETS:

Sys @ ORALOCAL (192.168.50.29)> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)> startup

ORACLE instance started.

Total System Global Area 135338868 bytes

Fixed Size 453492 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)> exit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0-Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0-Production

D: \ oracle \ ora92 \ database>

D: \ oracle \ ora92 \ database>

D: \ oracle \ ora92 \ database>

### Change SQLNET. AUTHENTICATION_SERVICES = (ETS) back.

D: \ oracle \ ora92 \ database> sqlplus "/as sysdba"

SQL * Plus: Release 9.2.0.1.0-Production on Fri May 16 22:03:59 2008

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus

D: \ oracle \ ora92 \ database>

D: \ oracle \ ora92 \ database>

D: \ oracle \ ora92 \ database>

D: \ oracle \ ora92 \ database> sqlplus "sys/mypassword as sysdba"

SQL * Plus: Release 9.2.0.1.0-Production on Fri May 16 22:04:07 2008

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Connected:

Oracle9i Enterprise Edition Release 9.2.0.1.0-Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0-Production

Sys @ ORALOCAL (192.168.50.29)> exit

Here, we can see that the new password takes effect only after the database is restarted. At the same time, we can see that you cannot log on with OS authentication, but you can log on through the network (with @ sid.

D: \ oracle \ ora92 \ database> sqlplus "/as sysdba"

SQL * Plus: Release 9.2.0.1.0-Production on Sat May 17 00:58:32 2008

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus

D: \ oracle \ ora92 \ database>

D: \ oracle \ ora92 \ database> sqlplus "sys/mypassword as sysdba"

SQL * Plus: Release 9.2.0.1.0-Production on Sat May 17 00:59:15 2008

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Connected:

Oracle9i Enterprise Edition Release 9.2.0.1.0-Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0-Production

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)>

Sys @ ORALOCAL (192.168.50.29)> exit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0-Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0-Production

D: \ oracle \ ora92 \ database> sqlplus "sys/mypassword @ oralocal as sysdba"

SQL * Plus: Release 9.2.0.1.0-Production on Sat May 17 00:59:38 2008

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Connected:

Oracle9i Enterprise Edition Release 9.2.0.1.0-Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.1.0-Production

Sys @ ORALOCAL (192.168.50.29)>

[1] [2] [3]