ORA-01031: insufficient privileges solution ################################### ##########
#
# NAME: troubleshoot connect internal.txt
#
# DESCRIPTION:
# Connect internal
# Connect/as sysdbaPassword problems:
# Refer (METALINK, OracleDOC ),
# Metalink search words (connect internal)
# NOTE:
#
# Modifiy (MM/DD/YY) AUTHOR
#05/03/03 ZORROL
######################################## #####
--------------------
CheckSqlnet. oraFile.
Sqlnet. oraFile Corruption or incorrect format can cause this problem.
Sqlnet. oraThe possible file storage path is
$ TNS_ADMIN/sqlnet. ora
If no$ TNS_ADMINBy default$ ORACLE_HOME/network/admin/sqlnet. ora
Or
$ HOME/sqlnet. ora
(1 ).You can copy a file from another machine.Sqlnet. ora.
---CheckSqlnet. oraFile Content
(2 ).CheckSQLNET. AUTHENTICATION_SERVICES
If notDblink.Check this row and set
SQLNET. AUTHENTICATION_SERVICES = (BEQ, NONE)
(3). SQLNET. CRYPTO_SEED You can add the above black lines. The modified sqlnet. ora result is as follows:
- # Sqlnet. ora Network Configuration File:/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet. ora
- # Generated by Oracle configuration tools.
- NAMES. DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
- ADR_BASE=/Oracle/app/oracle
- # HUZIA 2011.08.31
- Sqlnet. authentication_services= (BEQ, NONE)
- ~
- ~
In fact, sqlnet. authentication_services = (BEQ, NONE), this parameter can also have many options, such.
~
~
Ps: Red Hat enterprise linux 5.5 + oracle 11gr2