[Oracle]-[sqlplus/as sysdba logon Error]-New users use sqlplus/as sysdb

[Oracle]-[sqlplus/as sysdba logon Error, sqlplus/as sysdba returns an error, which is strange, so it is simulated in its own VM. A test user is created:

[test@liu bin]# ./sqlplus Error 6 initializing SQL*PlusMessage file sp1<lang>.msb not foundSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

 

You need to set the ORACLE_HOME environment variable.

[test@liu bin]# export ORACLE_HOME=/opt/oracle/102

 

Run:

[test@liu bin]# ./sqlplussqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

 

Dizzy... It seems that the dynamic link library is not found, but LD_LIBRARY_PATH and so on are useless. After checking it, it may be caused by $ ORACLE_HOME permission. Therefore, execute:

chmod -R a+rX /opt/ora10/

 

Now you can execute. Execute again:

[test@liu bin]# ./sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 9 04:20:47 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.ERROR:ORA-12162: TNS:net service name is incorrectly specified

 

The problem is the same as that mentioned earlier. Set ORACLE_SID and run the command.

[test@liu bin]# export ORACLE_SID=bisal[test@liu bin]# ./sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 9 04:21:08 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.ERROR:ORA-01031: insufficient privileges

 

The error message is missing, indicating that it may be related to the failure to set ORACLE_SID. Solve the problem below. Original/etd/group: oinstall: x: 501: Add test to oinstall group: oinstall: x: 501: test. A permission issue is also prompted. But use sqlplus/nolog, and then conn a/B can log on. ... It turns out to be a user group problem. The test user must be added to the dba. Because sqlplus/as sysdba has the SYS permission by default, use/usr/sbin/usermod-a-G dba test and execute:

[test@liu admin]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 9 05:10:31 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options

 

Everything is so natural... Note: sqlnet. ora is not set here:

SQLNET_AUTHENTICATION_SERVICES= (NTS)

 

Only:

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)