CentOS 7上启动Oracle 11.2.0.3
来源:互联网 发布:路老膏方 诈骗让网络 编辑:程序博客网 时间:2024/06/06 17:43
1.正常安装Oracle 11,执行root脚本,等等。
2. 安装后重启服务器。
3. 重启后,用 su - oracle 命令后,检查oracle用户的环境变量:
- declare -x ORACLE_HOME="/home/oracle/app/oracle/product/11.2.0/dbhome_1"
- declare -x ORACLE_SID="orcl"
- [oracle@oracle admin]$ cat listener.ora
- # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- # Generated by Oracle configuration tools.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (SID_NAME = orcl)
- (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
- )
- )
- LISTENER =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.33.212)(PORT = 1521))
- )
- )
- ADR_BASE_LISTENER = /home/oracle/app/oracle
重点检查其中的SID,HOST,PORT,ORACLE_HOME是否正确。如果不正确客户端会报告ERROR-ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务 错误。
如果没有问题,进入$ORACLE_HOME/bin,启动监听器:
- [oracle@oracle bin]$ ./lsnrctl
- LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-DEC-2014 11:22:03
- Copyright (c) 1991, 2011, Oracle. All rights reserved.
- Welcome to LSNRCTL, type "help" for information.
- LSNRCTL> start
- Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
- TNSLSNR for Linux: Version 11.2.0.3.0 - Production
- System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- Log messages written to /home/oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.16.33.212)(PORT=1521)))
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.16.33.212)(PORT=1521)))
- STATUS of the LISTENER
- ------------------------
- Alias LISTENER
- Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
- Start Date 16-DEC-2014 11:22:07
- Uptime 0 days 0 hr. 0 min. 0 sec
- Trace Level off
- Security ON: Local OS Authentication
- SNMP OFF
- Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
- Listener Log File /home/oracle/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.16.33.212)(PORT=1521)))
- Services Summary...
- Service "orcl" has 1 instance(s).
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- The command completed successfully
- LSNRCTL>
- [oracle@oracle bin]$ ./sqlplus '/ as sysdba'
- SQL> startup
- ORACLE instance started.
- Total System Global Area 960372736 bytes
- Fixed Size 2234160 bytes
- Variable Size 557844688 bytes
- Database Buffers 394264576 bytes
- Redo Buffers 6029312 bytes
- Database mounted.
- Database opened.
5. Centos7自带了SELINUX,关掉
6. Centos7自带了下一代防火墙firewalld,关掉,否则客户端连接过来会报TNS Timeout异常
- [root@oracle ~]# service firewalld stop
- Redirecting to /bin/systemctl stop firewalld.service
===============================================
现在其它机器就应该可以正常连接并使用Oracle了。
另:装Oracle最省事的还是在Oracle自己的Enterprise Linux上安装。那些依赖,系统参数,等等等都不需要设置了。
0 0
- CentOS 7上启动Oracle 11.2.0.3
- CentOS 7上启动Oracle 11.2.0.3
- Centos上Oracle-启动及DBCA配置
- 在CentOS 7上安装Oracle 11.2.0.3
- CentOS 6.4上安装Oracle 11.2
- Tomcat 7 在 Centos 6 上启动慢的解决办法
- centos 7 上配置mysql 开机启动详解
- centos上安装 oracle jdk7
- VM上Centos安装oracle
- centos 6.5_x64上静默模式安装oracle 11.2.0.1
- CentOS 7 上安装 Oracle 数据库 12c
- linux下手工启动oracle centos下手动启动oracle
- linux下手工启动oracle centos下手动启动oracle
- linux下手工启动oracle centos下手动启动oracle
- linux下手工启动oracle centos下手动启动oracle
- CentOS上可用的nginx启动脚本
- CentOS上可用的nginx启动脚本
- CentOS上tomcat启动巨慢问题
- 重新学习C# 之 数据类型(一)
- 趣谈i++与++i
- JavaWeb中Dao层的接口和基本功能简单抽取技巧
- python日期
- iOS自定义相机
- CentOS 7上启动Oracle 11.2.0.3
- c++primer plus 编程练习题2
- iOS 打包ipa的方法
- ASI同步(AFN做不到的东西)
- 【微信链接3种方式】
- Java集合总体框架
- 局部变量、全局变量和静态变量的关系。
- 【SSH】——Struts2中的动态方法调用(一)
- Android画图之setXfermode处理两图相交叉的情况