# oracle_silent

**Repository Path**: ecode_cloud/oracle_silent

## Basic Information

- **Project Name**: oracle_silent
- **Description**: oracle_silent
oracle 11g 单机自动化安装shell脚本(静默安装)

- **Primary Language**: Shell
- **License**: WTFPL
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 29
- **Created**: 2020-12-11
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# oracle_silent
#### oracle 11g  通过自动应答文件 单机自动化安装shell脚本

## 使用方法：
	* 以root身份运行 install-oracle11g.sh
	* 以oracle身份执行下面的命令，也就是上面脚本后面注释的部分
<pre> 
su - oracle
cd /u01/oracle/database
./runInstaller -silent -force -responseFile /home/oracle/db.rsp
dbca -silent -responseFile /home/oracle/dbca.rsp
netca -silent -responsefile /u01/oracle/database/response/netca.rsp
cp oracle.init.d /etc/init.d/oracle # 这里注意执行权限
chkconfig oracle on

ORA-01081 解决方法：
sqlplus>shutdown abort;
sqlplus>startup;

# 如果想要开机启动实例必须修改下面为Y
vim  /etc/oratab
orcl:/u01/oracle/product/11.2.0/dbhome_1::N 
改
orcl:/u01/oracle/product/11.2.0/dbhome_1:Y


# 数据库端口配置文件
# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
# 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/oracle
# 如果是 idea 链接可不加下面代码端口监听
SID_LIST_LISTENER =
	(SID_LIST =
	(SID_DESC =
		(SID_NAME = PLSExtProc)
		(ORACLE_HOME = /u01/oracle/product/11.2.0/dbhome_1) # 这个是oracle安装路径
		(PROGRAM = extproc)
	)
	(SID_DESC =
		(GLOBAL_DBNAME = orcl)
		(ORACLE_HOME = /u01/oracle/product/11.2.0/dbhome_1) # 这个是oracle安装路径
		(SID_NAME = orcl) # 这个是oracle安装时你指定的sid（全局标识符）
	)
)

</pre>
## 用到的命令
<pre>

# 检测监听端口命令
netstat -tnulp | grep 1521

# 进入sqlplus命令
sqlplus "/ as sysdba"

# 启动实例命令
SQL>startup

# 关闭实例命令
SQL>shutdown immediate

# 启动停止重启服务
service oracle start|stop|restart


</pre>


## 默认设置：

ORACLE_SID=orcl

## oracle11g 下载

[百度网盘]
(链接: https://pan.baidu.com/s/1vBcJSheEGHgRGfOtnlOFSQ 提取码: nvpn)

## TODO