From: http://www.chinaunix.net/jh/19/132866.html
######################################## #####
#
# Name: troubleshoot connect internal.txt
#
# Description:
# Connect internal
# Connect/As sysdba Password problems:
# Refer (Metalink, oracledoc ),
# Metalink search words (connect internal)
# Note:
#
# Modifiy (mm/DD/yy) Author
# 05/03/03 Zorrol
######################################## #####
--------------------
1 . Check Sqlnet. ora File .
Sqlnet. ora File Corruption or incorrect format can cause this problem.
Sqlnet. ora The possible file storage path is
$ Tns_admin/sqlnet. ora
If no $ Tns_admin By default $ ORACLE_HOME/Network/admin/sqlnet. ora
Or
$ Home/sqlnet. ora
(1 ). You can copy a file from another machine. Sqlnet. ora .
--- Check Sqlnet. ora File Content
(2 ). Check Sqlnet. authentication_services
If not Dblink. Check this row and set
Sqlnet. authentication_services = (beq, none)
(3). sqlnet. crypto_seed
In UNIX This parameter is not required. If this row exists, comment out or delete it.
(4). automatic_ipc
If this parameter is On , Will be forced to use "Two_task" Connection
It is best to set Off
Automatic_ipc = off
2. Check the permission configuration of related files.
Find $ Tns_admin /*
$ CD $ tns_admin
$ Chmod 644 sqlnet. ora tnsnames. ora listener. ora
$ LS-l sqlnet. ora tnsnames. ora listener. ora
-RW-r -- 1 Oracle DBA 1628 Jul 12 listener. ora
-RW-r -- 1 Oracle DBA 586 Jun 1 sqlnet. ora
-RW-r -- 1 Oracle DBA 82274 Jul 12 tnsnames. ora
3. Check operating system settings.
(1). $ ORACLE_HOME Is the environment variable set correctly?
% Cd $ ORACLE_HOME
% Pwd
If an error occurs, reset the settings:
Sh or KSh :----------
$ ORACLE_HOME = <path_to_oracle_home>
$ Export ORACLE_HOME
Example:
$ ORACLE_HOME =/u01/APP/Oracle/product/ 7.3.3
$ Export ORACLE_HOME
CSH :----
% Setenv ORACLE_HOME <path_to_oracle_home> example:
% Setenv ORACLE_HOME/u01/APP/Oracle/product/7.3.3
In addition $ ORACLE_HOME The path should be the actual path, not the directory connection ( Ln-S)
(2) $ oracle_sid Set correctly or not;
% Echo $ oracle_sid
(3 ). Are you sure you have not set $ Two_task
Check "Two_task" Set or not:
Sh, KSh or on HP/UX only CSH:
-----------------------------------
Env | grep-I two
-Or-
Echo $ two_task
CSH:
----
Setenv | grep-I two
If a row is returned, for example :
Two_task =
-Or-
Two_task = Prod
You need to cancel the environment variable settings. :
Sh or KSh:
----------
Unset two_task
CSH:
----
Unsetenv two_task
(4) Check Oracle File Permissions :
% Cd $ ORACLE_HOME/bin
% Ls-l Oracle
The permission should be: Rwsr-s -- X, or 6751.
If not:
% Chmod 6751 Oracle
(5 ). Check whether the currently connected operating system user is "Osdba" And it has been defined in:
"$ ORACLE_HOME/rdbms/lib/config. s"
Or
"$ ORACLE_HOME/rdbms/lib/config. c ".
Generally DBA
% ID uid = 1030 (Oracle) gid = 1030 (DBA)
If "Gid" Yes "Dba" , "Config. s" or "config. c"
There should be :/* 0x0008 15 */. ASCII "dba \ 0"
If the current operating system user is not added DBA Group, or manually edit and change Config. c And : % Relink Oracle
(6 ). The required file system is correct Mount
% Mount
(7) Whether the current identity is "Root" And operating system environment variables "User", "username", and "LOGNAME" Not set "Root ".
Root Users are special cases , Unless the current group is DBA Group , Otherwise, no Connect internal.
Set Root Change the current user group DBA GROUP:
# Newgrp DBA
----- It is best not to use Root Manage databases ;
(8 ). Check "/Etc/group ":
Duplicate row?
% Grep DBA/etc/group
DBA: 1010:
DBA: 1100:
If yes, it is useless to delete it.
(9 ). Be sure to stop Instance No memory usage
For example: IPCS-B
T ID key mode owner group segsz
shared memory:
M 0 0x50000ffe -- RW-r -- root Root 68
M 1601 0x0eedcdb8 -- RW-r ----- Oracle DBA 4530176
We can see that 1601 Quilt Oracle Use, delete .
------- Check whether multiple Instance
% Ipcrm-M 1601
(10 ). If there are Ora-12705 Check the environment variables for errors:
"Ora_nls", "ora_nls32", "ora_nls33" , "Nls_lang ".
(11 ). Check "ORACLE_HOME" and "LD_LIBRARY_PATH Environment variable:
$ LD_LIBRARY_PATH = $ ORACLE_HOME/lib
$ Export LD_LIBRARY_PATH
$ ORACLE_HOME =/u01/APP/Oracle/product/8.0.4
$ Export ORACLE_HOME
(12 ). Current Instance Whether the attached disk has sufficient disk space
DF-K
(13 ). User pair /Etc/passwd Whether you have read permission.
(14 ). If you use MTS Method, make sure your connection is used Dedicade Server Method.
(15 ). Install Oracle Whether all OS patches are required. Oracle Patch to the latest version?
Trackback: http://tb.blog.csdn.net/TrackBack.aspx? Postid = 218631
