环境版本:AIX 6.1 oracle 11.2.02
正常安装完数据库,新建了ogg用户,所属组为dba和oinstall。
settledb01:/ #id ogg
uid=1003(ogg) gid=510(dba) groups=511(oinstall)
listener状态也是正常:
settledb01:/oracle >lsnrctl status listener_settle
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 13-AUG-2012 10:58:02
Copyright (c) 1991, 2010, Oracle.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sett_svc1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
Version
Start Date
Uptime
Trace Level
Security
SNMP
Listener Parameter File
Listener Log File
Listening Endpoints Summary...
Services Summary...
Service "settledb" has 2 instance(s).
Service "settledbXDB" has 1 instance(s).
The command completed successfully
使用oracle用户登录,一切正常:
settledb01:/oracle >sqlplus goldengate/goldengate
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:58:48 2012
Copyright (c) 1982, 2010, Oracle.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
settledb01:/oracle >sqlplus goldengate/goldengate@settledb
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:58:58 2012
Copyright (c) 1982, 2010, Oracle.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
但是使用新建的系统用户ogg登录,出现如下情况:
settledb01:/ogg/software >sqlplus goldengate/goldengate@settledb
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:59:41 2012
Copyright (c) 1982, 2010, Oracle.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
settledb01:/ogg/software >sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:39:28 2012
Copyright (c) 1982, 2010, Oracle.
SQL> conn /as sysdba
ERROR:
ORA-12547: TNS:lost contact
SQL> exit
报出了ORA-12547: TNS:lost contact错误。
检查$ORACLE_HOME/bin/oracle权限
settledb01:/oracle/app/oracle/product/11.02/db_1/bin >ls -al oracle
-rwxr-xr-x
发现没有s权限。
解决措施:
增加$ORACLE_HOME/bin/oracle文件的s权限
settledb01:/oracle/app/oracle/product/11.02/db_1/bin >chmod +s oracle
settledb01:/oracle/app/oracle/product/11.02/db_1/bin >ls -al oracle
-rwsr-sr-x
测试:
settledb01:/ #su - ogg
settledb01:/ogg/software >sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:46:12 2012
Copyright (c) 1982, 2010, Oracle.
SQL> conn /as sysdba
Connected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
故障解决