How to install ORACLE silently

How to install ORACLE silently

In this experiment, I copied the previous virtual machine directly, deleted the oracle installed on the graphical interface, and re-installed it. Therefore, I need to modify some configurations here.

First, modify our IP address.

# system-config-network

After that, modify the hosts file and change the IP address.

# vi /etc/hosts

Next, we will delete the ORACLE file that was last installed.

# cd $ORACLE_BASE# ls# rm -rf *

Enter root: rm-rf/etc/ora *
Or configure before installation.
Then perform the Silent Installation. First, we need to create a corresponding file, which records all the processes of oracle installation.

[oracle@oracle ~]$ cd /u01/database/response$ cp enterprise.rsp /u01$ vi /u01/enterprise.rsp

Modify the following content:

35 UNIX_GROUP_NAME=\"oinstall\" 62 ORACLE_HOME=\"/u01/app/oracle/10.2.0/db_1\" 70 ORACLE_HOME_NAME=\"OraDbHome1\" 351 COMPONENT_LANGUAGES={\"en,zh_CN\"} 384 s_nameForDBAGrp=\"dba\" 392 s_nameForOPERGrp=\"oper\" 422 n_configurationOption=3

Start installation:

[oracle@oracle ~]$ cd /u01/database$ ./runInstaller -silent -responseFile /u01/enterprise.rsp

Run the following script after installation.

$ORACLE_BASE/oraInventory/orainstRoot.sh$ORACLE_HOME/root.sh

After the script is executed, use sqlplus/as sysdba to know that the oracle version is 10.2.0.1.0.
Silent Database Upgrade

$ Cp/u01/Disk1/response/patchset. rsp/u01vi/u01/patchset. edit the following line for rsp: 45 UNIX_GROUP_NAME = \ "oinstall \" 87 ORACLE_HOME = \ "/u01/app/oracle/10.2.0/db_1 \" 99 ORACLE_HOME_NAME = \ "OraDbHome1 \" 533 MYORACLESUPPORT_USERNAME = \ "zhaoming@sina.com \ "542 MYORACLESUPPORT_PASSWORD = \" B \ "603 DECLINE_SECURITY_UPDATES = true

Install and upgrade Patches

$ ./runInstaller -silent -responseFile /u01/patchset.rsp

Upgrade successful

$ sqlplus / as sysdba;Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options

Next, create a database manually.

$ Vi $ ORACLE_HOME/dbs/initorcl. ora writes the following content: compatible = 10.2.0.5instance _ name = orcldb_name = orclsga_target = region = bandwidth = 10undo_management = autoundo_tablespace = region = $ ORACLE_BASE/admin/orcl/region = $ ORACLE_BASE /admin/orcl/cdumpuser_dump_dest = $ ORACLE_BASE/admin/orcl/udumpcontrol_files = \ '/u01/app/oracle/oradata/orcl/control01.ctl \', \ '/u01/app/oracle/oradata/orcl/control02.ctl \' Save and exit

Create a trail directory:

mkdir -p $ORACLE_BASE/admin/orcl/{a,b,c,u}dump

Create Control File Location

mkdir -p /u01/app/oracle/oradata/orcl/

Start to instance:

sqlplus / as sysdbacreate spfile from pfile;startup nomount

Next, create a database.
Vi createdb. SQL writes the following content:

Create database orcl user sys identified by a --- here you need to modify your password user system identified by a logfile group 1 (\ '/u01/app/oracle/oradata/orcl/redo01.log \') SIZE 50 M, GROUP 2 (\ '/u01/app/oracle/oradata/orcl/redo02.log \') SIZE 50 M, GROUP 3 (\ '/u01/app/oracle/oradata/orcl/redo03.log \') SIZE 50 m maxlogfiles 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 MAXINSTANCES 1 character set utf8 national character set utf8 DATAFILE \ '/u01/app/oracle/oradata/orcl/system01.dbf \ 'size 325 M reuse extent management local sysaux datafile \ '/u01/app/oracle/oradata/orcl/sysaux01.dbf \ 'size 325 m reuse default tablespace users datafile \'/u01/app/oracle/oradata /orcl/users01.dbf \ 'size 200 m default temporary tablespace temp TEMPFILE \ '/u01/app/oracle/oradata/orcl/temp01.dbf \ 'size 20 m reuse undo tablespace undotbs DATAFILE \' /u01/app/oracle/oradata/orcl/undotbs01.dbf \ 'size 200 m reuse autoextend on maxsize unlimited/

Then reference these scripts in SQL

SQL> get/u01/create. SQL --- explains the function of get: reference any file in the operating system directory to be introduced to SQL. SQL>... SQL>/

----- After these script statements are executed, control files, data files, log files, and so on will be generated at the corresponding location ----
Then execute

sql>desc dba_tablesERROR:ORA-04043: object dba_tables does not exist

---- Explanation: the data dictionary is queried here. We have only created a database and have not created any views, tables, indexes, and data dictionaries related to the database. ----
So we need to create these views, tables, and indexes.

$ Cd/u01vi jb. SQL writes the following content :@? /Rdbms/admin/catalog. SQL ---- catalog. SQL: create a data dictionary @? /Rdbms/admin/catproc. SQL ---- catproc. SQL: Install the ORACLE custom package conn system/@? /Sqlplus/admin/pupbld. SQL ---- pupbld. SQL: block sqlplus errors

Then execute this script in the database:

sql>@/u01/jb.sql

--- Here is an explanation: @: You can execute SQL statements in a script in the operating system.

Then there is a long wait. It may take more than 20 minutes.

After the execution is complete, you will see many tables, views, and so on. does not exist. You don't need to worry about it. This is when you create a data dictionary, you first query the tables that do not exist. Of course it does not exist. Because it has not been created, an error is reported.

sql>desc dba_tables

After that, there will be content.

sql> select count(*) from dba_tables

Next we will install the OEM, And we will patch the patch before installation. We also use a no-Mo patch. Patch:

p8350262_10205_Generic.zip

Upload the patch to the directory: $ ORACLE_HOME/OPatch/decompress:
$ Unzip p8350262_10205_Generic.zip
Get a directory: 8350262
Patch:

$ emctl stop dbconsole$ cd $ORACLE_HOME/OPatch$ ./opatch apply 8350262

After the patch is installed

$ Lsnrctl status: No Listener

Then we do:

$ cd /u01/database/response/$ cp netca.rsp /u01$ netca /silent /responseFile /u01/netca.rsp

After the listener is installed, we enter sqlplus to register the database to this listener.

$ sqlplus / as sysdba;sqlplus>alter system register

After the listener is installed, We will install the database.

SQL> select username from dba_users where username=\'SYSMAN\';     no rows selected

Run the following command to install the database:

$ emca -repos create STARTED EMCA at Mar 30, 2013 9:57:23 AMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.Enter the following information:Database SID: orclListener port number: 1521Password for SYS user: Password for SYSMAN user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: YMar 30, 2013 9:58:28 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-03-30_09-57-2-AM.log.Mar 30, 2013 9:58:28 AM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...Mar 30, 2013 10:00:42 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdEnterprise Manager configuration completed successfullyFINISHED EMCA at Mar 30, 2013 10:00:42 AM

After the database is installed, We will install the console:

$ emca -config dbcontrol dbSTARTED EMCA at Mar 30, 2013 10:01:47 AMEM Configuration Assistant, Version 10.2.0.1.0 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.Enter the following information:Database SID: orclListener port number: 1521Password for SYS user: Password for DBSNMP user: Password for SYSMAN user: Invalid username/password.Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): -----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/app/oracle/10.2.0/db_1Database hostname ................ hndxListener port number ................ 1521Database SID ................ orclEmail address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... -----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: YMar 30, 2013 10:02:42 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/app/oracle/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-03-30_10-01-4-AM.log.Mar 30, 2013 10:02:48 AM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Mar 30, 2013 10:04:24 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyMar 30, 2013 10:04:24 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is http://hndx:1158/em <<<<<<<<<<<Enterprise Manager configuration completed successfullyFINISHED EMCA at Mar 30, 2013 10:04:24 AM

It's almost done.
$ Firefox http: // hndx: 1158/em -- if the error message "username and password" is returned, create a password file first:
Create a password file:

Orapwd file = $ ORACLE_HOME/dbs/orapworcl password = xxxxx --- user defined

Is the UI of Firefox very friendly. It is estimated that there will be an error here, that is, to add the certificate. After Entering, add and click Add below.

How to install oracle11g silently

First, we should deny the upstairs statement. Silent Installation can even be achieved by combining scripts with response files for silent automatic installation. You can refer to the following article as an entry.
Www.cnblogs.com/..3.html
 
How to install oracle xe silently

Hi.
We are lucky to see your problem.
However, it is a pity that no one has answered your questions. Maybe you have already found the answer somewhere else. Congratulations.
Maybe the question you asked is a little professional, and no one will. Or someone else has not encountered or encountered your problems, so they cannot help you. We recommend that you go to the relevant forums for help. There are usually many people there and you are enthusiastic about it. It may help you solve the problem quickly.
Good luck ~!
I hope my answers will help you!
Thank you.