10Grac,安装后状态正常但是sqlplus不能连接数据库

午夜幽魂

在vbox虚拟机上装的10Grac，装完后状态正常，但是在sqlplus里不能连接数据库，怪事，求大侠帮忙看看。

zhuang3088

午夜幽魂？？？是LU里的那位大牛吗？

午夜幽魂

呀，被人发现了，可惜我不是大牛，小弟一个，呵呵

Maclean Liu(刘相兵

echo $ORACLE_SID
echo $ORACLE_HOME

ps -ef|grep smon|grep -v grep |awk '{print "/proc/"$2"/environ"}'|xargs cat

午夜幽魂

Maclean Liu(刘相兵 发表于 2013-4-11 23:33
echo $ORACLE_SID
echo $ORACLE_HOME

你好，
下面是两个节点的运行结果，
我是安照你那个10GRAC安装的视频安装的，今天又安装了一次，还是这个情况，
有点搞不懂为什么了，求教，谢谢
[oracle@rac1 rac1]$ echo $ORACLE_SID
hell1
[oracle@rac1 rac1]$ echo $ORACLE_HOME
/u01/oracle/product/10.2.0/database/

[oracle@rac1 rac1]$ ps -ef|grep smon|grep -v grep |awk '{print "/proc/"$2"/environ"}'|xargs cat
ORACLE_SID=+ASM1ORACLE_HOME=/u01/oracle/product/10.2.0/databasePATH=LD_LIBRARY_PATH=/u01/oracle/product/10.2.0/database/lib:/u01/oracle/product/10.2.0/database/jdk/jre/lib/i386/client:/u01/oracle/product/10.2.0/database/jdk/jre/lib/i386:/u01/oracle/product/10.2.0/database/jdk/jre/../lib/i386:/u01/oracle/product/10.2.0/database/lib32:/u01/oracle/product/10.2.0/database/network/lib32:/u01/oracle/product/10.2.0/database/lib:/u01/oracle/product/10.2.0/database/network/libORA_NET2_DESC=8,11ORACLE_SPAWNED_PROCESS=1SKGP_HIDDEN_ARGS=<FATAL/S/x0/xB/x0/xC94112/17186/17186/xA>0_USR_ORA_INST_NOT_SHUTDOWN=_CAA_OPTIONAL_RESOURCES=ORA_CRS_HOME=/u01/oracle/product/10.2.0/crsSELINUX_INIT=YESCONSOLE=/dev/console_USR_ORA_LANG=_CAA_FAILOVER_DELAY=0TERM=linux_CAA_UPTIME_THRESHOLD=7d_CAA_STATE=:OFFLINE,_USR_ORA_PRECONNECT=none_USR_ORA_DEBUG=0_CAA_NAME=ora.hell.hell1.inst_CAA_REASON=user_USR_ORA_OPEN_MODE=open_CAA_FAILURE_INTERVAL=0_CAA_FAILURE_THRESHOLD=0_USR_ORA_CONNECT_STR=/ as sysdba_USR_ORA_FLAGS=LD_LIBRARY_PATH=/u01/oracle/product/10.2.0/database/lib:/u01/oracle/product/10.2.0/crs/lib_USR_ORA_START_TIMEOUT=0INIT_VERSION=sysvinit-2.86_USR_ORA_SRV=ORACLE_BASE=/u01/oracle/product/10.2.0/database_USR_ORA_VIP=_CAA_REQUIRED_RESOURCES=ora.rac1.ASM1.asm_CAA_HOSTING_MEMBERS=rac1_CAA_START_TIMEOUT=0_CAA_ACTION_SCRIPT=/u01/oracle/product/10.2.0/database/bin/racgwrap_CAA_STOP_TIMEOUT=0_CAA_AUTO_START=1PATH=_USR_ORA_NETMASK=RUNLEVEL=5_CAA_TARGET=:ONLINE,PWD=/u01/oracle/product/10.2.0/database/bin_USR_ORA_IF=_USR_ORA_ALERT_NAME=_USR_ORA_DISCONNECT=falsePREVLEVEL=N_CAA_PLACEMENT=restricted_USR_ORA_OPI=false_CAA_DESCRIPTION=CRS application for InstanceHOME=/SHLVL=1_CAA_SCRIPT_TIMEOUT=600_CAA_CLIENT_LOCALE=_USR_ORA_CHECK_TIMEOUT=0LD_ASSUME_KERNEL=_CAA_CHECK_INTERVAL=600_CAA_ACTIVE_PLACEMENT=0_CAA_TYPE=application_USR_ORA_STOP_TIMEOUT=0_USR_ORA_STOP_MODE=immediate_USR_ORA_PFILE=/u01/oracle/product/10.2.0/crs/racg/tmp/ora.hell.hell1.inst.ora_CAA_RESTART_ATTEMPTS=5ORACLE_HOME=/u01/oracle/product/10.2.0/databaseORACLE_CONFIG_HOME=/u01/oracle/product/10.2.0/crsORACLE_SID=hell1ORA_NET2_DESC=8,11ORACLE_SPAWNED_PROCESS=1SKGP_HIDDEN_ARGS=<FATAL/S/x0/xB/x0/xD92744/25306/25306/xA>0


[oracle@rac2 ~]$ echo $ORACLE_SID
hell2
[oracle@rac2 ~]$ echo $ORACLE_HOME
/u01/oracle/product/10.2.0/database/
[oracle@rac2 ~]$ ps -ef|grep smon|grep -v grep |awk '{print "/proc/"$2"/environ"}'|xargs cat
_USR_ORA_INST_NOT_SHUTDOWN=_CAA_OPTIONAL_RESOURCES=ORA_CRS_HOME=/u01/oracle/product/10.2.0/crsSELINUX_INIT=YESCONSOLE=/dev/console_USR_ORA_LANG=_CAA_FAILOVER_DELAY=0TERM=linux_CAA_UPTIME_THRESHOLD=7d_CAA_STATE=:OFFLINE,_USR_ORA_PRECONNECT=none_USR_ORA_DEBUG=0_CAA_NAME=ora.rac2.ASM2.asm_CAA_REASON=user_USR_ORA_OPEN_MODE=mount_CAA_FAILURE_INTERVAL=0_CAA_FAILURE_THRESHOLD=0_USR_ORA_CONNECT_STR=/ as sysdba_USR_ORA_FLAGS=LD_LIBRARY_PATH=/u01/oracle/product/10.2.0/database/lib:/u01/oracle/product/10.2.0/crs/lib_USR_ORA_START_TIMEOUT=0INIT_VERSION=sysvinit-2.86_USR_ORA_SRV=ORACLE_BASE=/u01/oracle/product/10.2.0/database_USR_ORA_VIP=_CAA_REQUIRED_RESOURCES=_CAA_HOSTING_MEMBERS=rac2_CAA_START_TIMEOUT=0_CAA_ACTION_SCRIPT=/u01/oracle/product/10.2.0/database/bin/racgwrap_CAA_STOP_TIMEOUT=0_CAA_AUTO_START=1PATH=_USR_ORA_NETMASK=RUNLEVEL=3_CAA_TARGET=:ONLINE,PWD=/u01/oracle/product/10.2.0/database/bin_USR_ORA_IF=_USR_ORA_ALERT_NAME=_USR_ORA_DISCONNECT=falsePREVLEVEL=N_CAA_PLACEMENT=restricted_USR_ORA_OPI=false_CAA_DESCRIPTION=CRS application for ASM instanceHOME=/SHLVL=1_CAA_SCRIPT_TIMEOUT=600_CAA_CLIENT_LOCALE=_USR_ORA_CHECK_TIMEOUT=0LD_ASSUME_KERNEL=_CAA_CHECK_INTERVAL=600_CAA_ACTIVE_PLACEMENT=0_CAA_TYPE=application_USR_ORA_STOP_TIMEOUT=0_USR_ORA_STOP_MODE=immediate_USR_ORA_PFILE=_CAA_RESTART_ATTEMPTS=5ORACLE_HOME=/u01/oracle/product/10.2.0/databaseORACLE_CONFIG_HOME=/u01/oracle/product/10.2.0/crsORACLE_SID=+ASM2ORA_NET2_DESC=8,11ORACLE_SPAWNED_PROCESS=1SKGP_HIDDEN_ARGS=<FATAL/S/x0/xB/x0/xBE707A/14377/14377/xA>0_USR_ORA_INST_NOT_SHUTDOWN=_CAA_OPTIONAL_RESOURCES=ORA_CRS_HOME=/u01/oracle/product/10.2.0/crsSELINUX_INIT=YESCONSOLE=/dev/console_USR_ORA_LANG=_CAA_FAILOVER_DELAY=0TERM=linux_CAA_UPTIME_THRESHOLD=7d_CAA_STATE=:OFFLINE,_USR_ORA_PRECONNECT=none_USR_ORA_DEBUG=0_CAA_NAME=ora.hell.hell2.inst_CAA_REASON=user_USR_ORA_OPEN_MODE=open_CAA_FAILURE_INTERVAL=0_CAA_FAILURE_THRESHOLD=0_USR_ORA_CONNECT_STR=/ as sysdba_USR_ORA_FLAGS=LD_LIBRARY_PATH=/u01/oracle/product/10.2.0/database/lib:/u01/oracle/product/10.2.0/crs/lib_USR_ORA_START_TIMEOUT=0INIT_VERSION=sysvinit-2.86_USR_ORA_SRV=ORACLE_BASE=/u01/oracle/product/10.2.0/database_USR_ORA_VIP=_CAA_REQUIRED_RESOURCES=ora.rac2.ASM2.asm_CAA_HOSTING_MEMBERS=rac2_CAA_START_TIMEOUT=0_CAA_ACTION_SCRIPT=/u01/oracle/product/10.2.0/database/bin/racgwrap_CAA_STOP_TIMEOUT=0_CAA_AUTO_START=1PATH=_USR_ORA_NETMASK=RUNLEVEL=3_CAA_TARGET=:ONLINE,PWD=/u01/oracle/product/10.2.0/database/bin_USR_ORA_IF=_USR_ORA_ALERT_NAME=_USR_ORA_DISCONNECT=falsePREVLEVEL=N_CAA_PLACEMENT=restricted_USR_ORA_OPI=false_CAA_DESCRIPTION=CRS application for InstanceHOME=/SHLVL=1_CAA_SCRIPT_TIMEOUT=600_CAA_CLIENT_LOCALE=_USR_ORA_CHECK_TIMEOUT=0LD_ASSUME_KERNEL=_CAA_CHECK_INTERVAL=600_CAA_ACTIVE_PLACEMENT=0_CAA_TYPE=application_USR_ORA_STOP_TIMEOUT=0_USR_ORA_STOP_MODE=immediate_USR_ORA_PFILE=/u01/oracle/product/10.2.0/crs/racg/tmp/ora.hell.hell2.inst.ora_CAA_RESTART_ATTEMPTS=5ORACLE_HOME=/u01/oracle/product/10.2.0/databaseORACLE_CONFIG_HOME=/u01/oracle/product/10.2.0/crsORACLE_SID=hell2ORA_NET2_DESC=8,11ORACLE_SPAWNED_PROCESS=1SKGP_HIDDEN_ARGS=<FATAL/S/x0/xB/x0/xCE23D0/21684/21684/xA>0[oracle@rac2 ~]$

Maclean Liu(刘相兵

实例运行的 环境变量 ORACLE_HOME=/u01/oracle/product/10.2.0/database

你的环境变量

[oracle@rac1 rac1]$ echo $ORACLE_HOME
/u01/oracle/product/10.2.0/database/

Maclean Liu(刘相兵

多了什么自己看， 还有这个Instance name真晦气

午夜幽魂

Maclean Liu(刘相兵 发表于 2013-4-12 23:25
实例运行的 环境变量 ORACLE_HOME=/u01/oracle/product/10.2.0/database

你的环境变量

一语道破天玑呀，果然如此，高人就是高人呀，!!!!

再问下，rac环境下，oracle的客户端应该怎么配置呢？

午夜幽魂

我客户端设置，测试都是成功的，tnsping也没有问题，但是就是用sqlplus连接不上，
总是提示
SQL> conn scott/tiger@test
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

望月飞鱼

ORA-12154: TNS:could not resolve the connect identifier specified
说的很清楚了呀
你@的是test吧