- 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 ---- explain: here the query is the data dictionary, we just created the database here, database-related views, tables, indexes, and data dictionaries are not created. ----
- 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.
Not pull, it is a word in the original literature net of smoke, rain, and red dust ......
Blizzard products must be excellent products
According to reliable news, BLZ is developing WAR4. It is certain that WAR4 is an instant strategy game that can surpass WAR3. On the other hand, it is also used to continue providing data sheets for WOW with WAR as the framework.