Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

4

主题
1#
发表于 2013-4-11 10:10:09 | 查看: 4723| 回复: 9
在vbox虚拟机上装的10Grac,装完后状态正常,但是在sqlplus里不能连接数据库,怪事,求大侠帮忙看看。

crs_stat状态正常
停rac有报错
启rac有报错
状态正常
进程ORA已经启动
rac正常运行
sid正确
sid没问题
2#
发表于 2013-4-11 13:36:16
午夜幽魂???是LU里的那位大牛吗?

回复 只看该作者 道具 举报

3#
发表于 2013-4-11 20:35:15
呀,被人发现了,可惜我不是大牛,小弟一个,呵呵

回复 只看该作者 道具 举报

4#
发表于 2013-4-11 23:33:36
echo $ORACLE_SID
echo $ORACLE_HOME

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

回复 只看该作者 道具 举报

5#
发表于 2013-4-12 13:32:28
本帖最后由 午夜幽魂 于 2013-4-12 13:35 编辑
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 ~]$

HELL1.jpg (44.43 KB, 下载次数: 423)

HELL1.jpg

hell2.jpg (59.42 KB, 下载次数: 427)

hell2.jpg

hell2.jpg (59.42 KB, 下载次数: 432)

hell2.jpg

HELL1.jpg (44.43 KB, 下载次数: 434)

HELL1.jpg

回复 只看该作者 道具 举报

6#
发表于 2013-4-12 23:25:51
实例运行的 环境变量 ORACLE_HOME=/u01/oracle/product/10.2.0/database

你的环境变量

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

回复 只看该作者 道具 举报

7#
发表于 2013-4-12 23:26:52
多了什么自己看, 还有这个Instance name真晦气

回复 只看该作者 道具 举报

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

你的环境变量

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

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

回复 只看该作者 道具 举报

9#
发表于 2013-4-13 10:48:33
我客户端设置,测试都是成功的,tnsping也没有问题,但是就是用sqlplus连接不上,
总是提示
SQL> conn scott/tiger@test
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

1.jpg
2.jpg
3.jpg

回复 只看该作者 道具 举报

10#
发表于 2013-4-16 16:05:50
ORA-12154: TNS:could not resolve the connect identifier specified
说的很清楚了呀
你@的是test吧

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-27 17:01 , Processed in 0.053558 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569