创建oracle实例
今天遇到了oracle软件已经安装但是实例没有创建的情况,然后同事给了我这样一个脚本亲测非常好用,借花献佛分享给大家:
cat /home/app/dbca_install.rsp
[GENERAL]
RESPONSEFILE_VERSION = “11.2.0.4”
OPERATION_TYPE = “createDatabase”
[CREATEDATABASE]
GDBNAME = “ORCL”
SID = “ORCL”
TEMPLATENAME = “General_Purpose.dbc”
STORAGETYPE=FS
DATAFILEDESTINATION =/oracle/oradata
#RECOVERYAREADESTINATION=/oracle/flash_recovery_area
CHARACTERSET = “AL32UTF8”
NATIONALCHARACTERSET= “AL16UTF16”
TOTALMEMORY = “700”
SYSTEMPASSWORD = “xxxx”
SYSPASSWORD = “xxxx”
检查环境变量:more .bash_profile
以静默模式安装:
dbca -silent -responseFile /home/app/dbca_install.rsp
查看进程正常
sqlplus进去提示如下:
原来问题出在这儿
解决这个问题后,再连就正常了