系统是RedHat 5.5,oracle安装的版本是10.2.0,在RH系统安装的时候一路正常,只是在检验的时候DHCP出了一个警告,忽略过去之后安装正常。安装完成之后启动监听和数据库都正常。然后重启之后变出现错误了。
我用oracle安装时候的用户登录:system,密码admin,数据库sid:orcl
打开监听成功之后,我在终端输入: sqlplus /nolog之后连接数据库:
SQL> conn system/admin
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
可是我在刚安装完成之后(没有重启电脑)连接却是很正常阿。请问这个是什么原因?
我贴上oracle下面的.bash_profile内容:
# .bash_profile# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
-----------------------------------------
顺便也贴上listener.ora 的内容:
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
)
)
---------------------------------
tnsnames.ora 的内容
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
------------------------------
请各位麻烦看下,到底是什么原因,安装完成的时候使用正常,重启电脑之后连系统默认的用户都连不上,在终端输入echo $ORACLE_HOME 和echo $ORACLE_SID都有显示正常,用sqlplus "/ as sysdba"登录也很正常。就是系统创建的system系统连接不上。请问这个是什么原因?望大家能够知道下小弟。谢谢!!!
我用oracle安装时候的用户登录:system,密码admin,数据库sid:orcl
打开监听成功之后,我在终端输入: sqlplus /nolog之后连接数据库:
SQL> conn system/admin
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
可是我在刚安装完成之后(没有重启电脑)连接却是很正常阿。请问这个是什么原因?
我贴上oracle下面的.bash_profile内容:
# .bash_profile# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
-----------------------------------------
顺便也贴上listener.ora 的内容:
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
)
)
---------------------------------
tnsnames.ora 的内容
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
------------------------------
请各位麻烦看下,到底是什么原因,安装完成的时候使用正常,重启电脑之后连系统默认的用户都连不上,在终端输入echo $ORACLE_HOME 和echo $ORACLE_SID都有显示正常,用sqlplus "/ as sysdba"登录也很正常。就是系统创建的system系统连接不上。请问这个是什么原因?望大家能够知道下小弟。谢谢!!!
解决方案 »
- 用BAT 执行SQL 时 为什么添加了两行。各路大神帮忙看下。
- oracle端口问题
- 關于監聽器
- 奇怪问题:为什么这样执行execute immediate 动态SQL不行?
- Oracle 9.2在RedHat9.0上安装的错误!请大侠们们出招!
- 求救:最简单的select * from table在sql*plus里都执行不起来。老是‘ORA-00942: 表或视图不存在’
- ASP+Oracle 9i(SQL*PLUS) 新增数据出错问题
- 请问oracle 中定位字符串位置的方法是什么呀, 如pos等 谢谢
- oracle 8i个人版的问题,捡分啊
- 急需personal oracle 8.0 !
- Oracle 的owner 和table_owner 有什么区别?如何修改Table_owner?
- win2003 至强处理器可以装oracle9I吗?SOLARIS系统下的9i数据备份后可以在win2003的oracle10g正常恢复吗?
sqlplus "/ as sysdba"这种方式是可以登陆的。
而sqlplus system/admin 这种方式需要数据库已经启动的情况下才可以使用,因为刚重启了电脑,数据库还没有启动,所以这种方式是登陆不上的。
如果有启动,看看linux的防火墙有没有关闭。