Warning: You are no longer connected to ORACLE.
SQL> !
[oracle@rac1 ~]$ ls -l /u01/sys_software/grid/product/11.2.0/dbhome_1/bin/oracle
-r-xr-sr-x 1 oracle asmadmin 210823898 Jan 10 15:52 /u01/sys_software/grid/product/11.2.0/dbhome_1/bin/oracle
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ chmod 6751 /u01/sys_software/grid/product/11.2.0/dbhome_1/bin/oracle
-r-xr-sr-x 1 oracle asmadmin 210823898 Jan 10 15:52 /u01/sys_software/grid/product/11.2.0/dbhome_1/bin/oracle
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ chmod 6751 /u01/sys_software/grid/product/11.2.0/dbhome_1/bin/oracle
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 24 21:40:42 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select instance_name from gv$instance;
INSTANCE_NAME
----------------
xhhdb1
xhhdb2
----------------
xhhdb1
xhhdb2
原因说明:
是因为$ORACLE_HOME/bin/oracle可执行文件的权限变更导致了该错误。
由于Oracle派生进程需要用到可执行文件oracle,所以该文件权限被修改之后派生进程会出现异常。因为监听派生进程,本质上会调用到$ORACLE_HOME/bin/oracle可执行文件派生。
一般监听发生问题不外乎检查如下四项:
1、/etc/hosts及域名解析配置文件
2、监听日志大小
3、监听状态
4、$ORACLE_HOME/oracle可执行文件权限
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8541492/viewspace-753256/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8541492/viewspace-753256/