在命令启动oracle时,出现ora-12547: tns:lost contact错误。中午好好的纳,下午就不管了。以为是链接失效,关机重启后还是不行。
运行环境:ubuntu+oracle 11.2.0
在命令启动oracle时,出现ora-12547: tns:lost contact错误。中午好好的纳,下午就不管了。以为是链接失效,,关机重启后还是不行。然后google了一把,找到了下面的解决方法。回想了一下,引起的原因是权限的问题,中午的时候不小心该了oracle安装目录的文件夹的权限,看来oracle的权限不能随便改动。
推荐阅读:
ora-01172、ora-01151错误处理
ora-00600 [2662]错误解决
ora-01078 和 lrm-00109 报错解决方法
ora-00471 处理方法笔记
ora-00314,redolog 损坏,或丢失处理方法
ora-00257 归档日志过大导致无法存储的解决办法
cause
1. this could be due to kernel parameters settings
2. incorrect permissions on the oracle executable
solution
to implement the solution, please execute the following steps:
1.
this could be due to kernel parameters settings
please check the notes below that provide the required settings for kernel parameters
note 169706.1 oracle database on aix,hp-ux,linux,macosx,solaris,tru64
note 201021.1 solaris: quick start guide - 9.2.0 rdbms installation
2.
this could be due to incorrect permissions on the oracle.exe
the 'ls' command should show permissions 6751 (as follows)
please check the following:
$ cd $oracle_home/bin
$ ls -l oracle
the output should be
-rwsr-s--x 1 oracle dba
if not then please execute the following
$ chmod 6751 oracle
please also verify if the following are correct
echo $oracle_home
echo $oracle_sid
echo $ld_library_path
echo $path
3.
if the above does not resolve i suggest that you shutdown the database and listener and then
relink all
note 131321.1 how to relink oracle database software on unix
完成以上步骤,再次启动oracle就ok了
本文永久更新链接地址:
