Linux+Oracle11G报错:
-
java.sql.SQLException: ORA-01034: ORACLE not available
-
ORA-27101: shared memory realm does not exist
-
Linux Error: 2: No such file or directory
解决 方法:
1、查看环境变量.bash_profile文件如下,查看oracle 实例名
[oracle@wpj ~]$ vi ~/.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 ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_ADMIN=$ORACLE_HOME/admin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jlib
export JAVA_HOME=$ORACLE_HOME/jdk
export ORA_NLS10=$ORACLE_HOME/nls/data
export PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/local/sbin:/usr/lib:$JAVA_HOME/bin
export PATH
2、修改 listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(GLOBAL_DBNAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.205.140)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
3、修改 tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.205.140)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
4、重启监听、数据库连接 试试
分享到:
相关推荐
Centos6.4安装Oracle11G,图形化界面安装
CentOS7下安装oracle11g具体步骤
在centos下安装oracle11g 使用yum源进行搭建 包括配置监听
pdksh-5.2.14-36.el5.i386.rpm
CentOS7离线安装oracle 11g_r2所有离线依赖包,并附详细安装说明,安装详细说明和依赖包,轻松在CentOS7安装oracle
centos 下安装oracle11g的文档
Centos 6.5 Oracle 11G R2 安装文档
Centos6.5下安装Oracle 11g.docxCentos6.5下安装Oracle 11g.docx
centos6.6 Oracle11G安装文档,能够帮助实施和初学linux成员快速掌握oracle的安装。
linux下安装oracle11g详细教程(每一步都有截图),按照文档步骤一定能安装成功。希望能对大家有所帮助
oracle11g安装手册-CentOS6.5 oracle11g安装手册-CentOS6.5
CentOS 6.4 安装 Oracle 11g,不是网络上拷贝,自己全程写下来的。
Centos7安装部署Oracle RAC 11G说明文档,Oracle 11g R2安装,RAC环境搭建
Oracle11G安装详解-Centos6.5操作系统下的安装详细流程文档。
centos 6下oracle 11g的安装配置 关于Oracle 11g安装配置详细说明,照着文档执行就可以安装成功oracle 11g ,本文档没有提供相关软件,需要自行下载。Vmware,centos 6,以及Oracle 11g
NULL 博文链接:https://java-doom.iteye.com/blog/1821918
centos7安装oracle11g操作文档
《在CentOS 7.1下安装Oracle 11gR2.docx》,自己试过了,安装包太大了,自己到oracle官网上下载;我下的是linux.x64_11gR2_database_1of2.zip,linux.x64_11gR2_database_2of2.zip
文档中按照步骤进行centos 7 下,针对oracle 11g 进行静默安装;
centos6.8上Oracle11g的安装,适合初学者安装学习,经试验无误