2006-4-11 14:39
abracadabra
oracle dbca 建库的问题
dbca 建库最后一步失去响应:
[oracle@hp380dl1 ~]$ ldd $ORACLE_HOME/bin/oracle |grep aio
libaio.so.1 => /usr/lib64/libaio.so.1 (0x0000002a96f44000)
正在检查操作系统程序包需求...
正在检查 make-3.79; 已发现 make-1:3.80-5。 通过
正在检查 binutils-2.14; 已发现 binutils-2.15.92.0.2-18。 通过
正在检查 gcc-3.2; 已发现 gcc-3.4.5-2。 通过
正在检查 libaio-0.3.96; 已发现 libaio-0.3.105-2。 通过
检查完成。此次检查的总体结果为: 通过
2006-4-12 00:07
charly
原来的环境变量:
[oracle@hp380dl1 ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/home/oracle/software/oracle
export ORACLE_HOME=$ORACLE_BASE/pruduct/10.2.0
[color=Red]export NLS_LANG=AMERICAN_AMERICAN.ZHS16GBK[/color]
export PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/lib
export ORACLE_SID=orcl64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/usr/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_ASSUME_KERNEL=2.6.9
[oracle@hp380dl1 ~]$
===============================
现在的环境变量:
[oracle@hp380dl1 ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export ORACLE_BASE=/home/oracle/software/oracle
export ORACLE_HOME=$ORACLE_BASE/pruduct/10.2.0
export NLS_LANG=AMERICAN_AMERICAN.ZHS16GBK
export PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/lib
export ORACLE_SID=orcl64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/usr/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
[color=Red]export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK[/color]
export LD_ASSUME_KERNEL=2.6.9
[oracle@hp380dl1 ~]$
2006-4-12 00:09
charly
这样就应该可以了
原来的错误信息:
[oracle@hp380dl1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 12 00:21:55 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect /as sysdba
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified
SQL>
================================
现在登陆Ok了:
[oracle@hp380dl1 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 12 00:20:34 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> exit
Disconnected
好了吱声。
2006-4-12 08:58
abracadabra
thanks.
看来是由这个笔误引起的环境变量问题?
这已经是第二个了,sigh.
[[i] 本帖最后由 abracadabra 于 2006-4-12 09:04 编辑 [/i]]
2006-4-12 09:11
abracadabra
原来可以 start 的,现在 start 报错?
[oracle@hp380dl1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-APR-2006 09:23:45
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hp380dl1.xhepc.com.cn)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@hp380dl1 ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-APR-2006 09:23:59
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/software/oracle/pruduct/10.2.0/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
2006-4-12 10:45
charly
/etc/hosts
内容检查一下
2006-4-12 11:13
abracadabra
[root@hp380dl1 etc]# cat hosts
# Do not remove the following line, or various programs
172.21.xx.9 hp380dl1
检查过了,仍然同样的问题。
web 管理,启动
错误消息 Io exception: The Network Adapter could not establish the connection
监听程序管理错误消息 不能执行监听程序管理, 因为 Oracle 主目录 "/home/oracle/software/oracle/pruduct/10.2.0" 不是安装服务器的目录。
[[i] 本帖最后由 abracadabra 于 2006-4-12 11:36 编辑 [/i]]
2006-4-12 22:35
charly
172.21.xx.9 hp380dl1
这个好像有问题,你把listener.ora里边得主机名改为IP试试看
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.