9、解压安装包:unzip linux.x64_11gR2_database_1of2.zip -d /data/database/#解压文件1unzip linux.x64_11gR2_database_2of2.zip -d /data/database/#解压文件2chown -R oracle:oinstall /data/database/database/#分配安装文件授权Oracle10、编辑Oracle数据库安装应答文件vim /data/database/database/response/db_install.rsporacle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=oinstalloracle.install.db.config.starterdb.globalDBName=orcloracle.install.db.config.starterdb.SID=sidOracle11GR2oracle.install.db.config.starterdb.characterSet=AL32UTF8oracle.install.db.config.starterdb.memoryOption=trueoracle.install.db.config.starterdb.memoryLimit=512oracle.install.db.config.starterdb.installExampleSchemas=falseoracle.install.db.config.starterdb.enableSecuritySettings=trueoracle.install.db.config.starterdb.password.ALL=111222@qazoracle.install.db.config.starterdb.control=DB_CONTROLoracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=falseoracle.install.db.config.starterdb.automatedBackup.enable=falseoracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGEoracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/data/oracle/oradataoracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/data/oracle/fast_recovery_areaDECLINE_SECURITY_UPDATES=true11、执行安装(进入/data/database/database/)[oracle@moke-1 ~]$ ./runInstaller -ignorePrereq -silent -force -responseFile /data/database/database/response/db_install.rsp12、已root用户执行脚本cd /data/oracle/product/11.2.0/db_1/ls./root.sh13、配置静默监听[oracle@moke-1 bin]$ netca /silent /responsefile /data/database/database/response/netca.rspbash: netca: command not found[oracle@moke-1 bin]$ echo $ORACLE_BASE[oracle@moke-1 bin]$ cd ~[oracle@moke-1 ~]$ vim .bash_profile[oracle@moke-1 ~]$ source .bash_profile[oracle@moke-1 ~]$ echo $ORACLE_BASE/data/oracle[oracle@moke-1 ~]$ echo $ORACLE_HOME/data/oracle/product/11.2.0/db_1[oracle@moke-1 ~]$ netca /silent /responsefile /data/database/database/response/netca.rspParsing command line arguments:Parameter "silent" = trueParameter "responsefile" = /data/database/database/response/netca.rspDone parsing command line arguments.Oracle Net Services Configuration:Profile configuration complete.Oracle Net Listener Startup:Running Listener Control:/data/oracle/product/11.2.0/db_1/bin/lsnrctl start LISTENERListener Control complete.Listener started successfully.Listener configuration complete.Oracle Net Services configuration successful. The exit code is 014、 查看监听端口[oracle@moke-1 oradata]$ netstat -tnulp | grep 1521(Not all processes could be identified, non-owned process infowill not be shown, you would have to be root to see it all.)tcp6 0 0 :::1521 :: LISTEN 12285/tnslsnr 15、静默创建数据库[root@moke-1 response]# vim dbca.rspGDBNAME = "qhzncs"SID = "orcl"SYSPASSWORD = "4900@qaz"CHARACTERSET = "ZHS16GBK"//执行静默建库[oracle@moke-1 response]$ dbca -silent -responseFile /data/database/database/response/dbca.rsp Copying database files1% complete3% complete11% complete18% complete26% complete37% completeCreating and starting Oracle instance40% complete45% complete50% complete55% complete56% complete57% complete60% complete62% completeCompleting Database Creation66% complete70% complete73% complete74% complete85% complete96% complete100% completeLook at the log file "/data/oracle/cfgtoollogs/dbca/qhzncs/qhzncs.log" for further details.//查看oracle实例进程[oracle@moke-1 response]$ ps -ef | grep ora_ | grep -v grep//查看监听状态[oracle@moke-1 admin]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-JUL-2018 17:17:37Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 05-JUL-2018 11:26:13Uptime 3 days 5 hr. 51 min. 26 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /data/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File /data/oracle/diag/tnslsnr/moke-1/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=moke-1.novalocal)(PORT=1521)))Services Summary...Service "orclXDB" has 1 instance(s).Instance "orcl", status READY, has 1 handler(s) for this service...Service "qhzncs" has 1 instance(s).Instance "orcl", status READY, has 1 handler(s) for this service...The command completed successfully//登录sqlplus,查看实例状态sqlplus / as sysdbaselect status from v$instance;//查看数据库编码select userenv('language') from dual;//查看数据库版本信息select * from v$version;//激活scott用户alter user scott account unlock;alter user scott identified by tiger;select username,account_status from all_users;select username,status from all_users;sqlplus scott/tiger@QHZNCSsqlplus scott/tiger@192.168.1.16:1521/QHZNCS
推荐阅读
- 安装漏洞靶场,让你也能体验做黑客的感觉
- CentOS7.9安装教程
- 电动窗帘安装方法有哪些
- CentOS系统下PXE服务器的搭建与部署
- 安装好SSL证书并强制HTTP转HTTPS
- 安装 Linux,只需三步
- 投影仪安装方式及注意事项
- 一篇详细的Debian系统安装配置手册
- nginx1.19.1自动安装部署脚本
- CentOS7下离线安装KubeSphere3.0集群
