2.2. Acercamientos desde la sociología al análisis de las masculinidades
2.2.3. Identidad, performance, poder: las masculinidades como diferencia
2.2.3.2. Las masculinidades como différance
To install oracle database patch. This installation takes Oracle 9.2.0.7 version as an example.
1. Confirm patches
i. Oracle 9.2.0.7 database update patch packet includes 32-bit and 64-32-bit software. Confirm the information before installing.
ii. For 32-bit operating system, install 32-bit oracle software.
For 64-bit operating system, install both 32-bit and 64-bit oracle software.
iii. 32-bit oracle software only can install 32-bit patch packet, and 64-bit oracle software only can install 64-bit patch packet.
f 32-bit patch packet is p4163445_92070_SOLARIS.zip
f 64-bit patch packet is p4163445_92070_SOLARIS64.zip
iv. Download the patch packet from
https://metalink.oracle.com.
v. Click login in metalink. Input user name and password (Please ask NM Development Department for them).
After login, select patches & Updates page, then select Simple Search link as shown in Figure 14.
Results
Purpose
Important Cautious Items
FI G U R E 1 4− DO W N L O A D PA T C H
vi. Open Simple Search page and input patch number to choose 32-bit or 64-bit oracle software as shown in Figure 15.
FI G U R E 1 5− P AT C H SE A R C H I N G
vii. Click Go to search patch result as shown in Figure 16.
Click Download to start downloading.
Chapter 2 Database Installation
FI G U R E 1 6 − PA T C H SE A R C H I N G RE S U L T
2. To verify Oracle product is 32-bit or 64-bit:
Input commands under oracle user command (su – oracle):
sqlplus “/as sysdba”
The result is as follows:
# su - oracle
Sun Microsystems Inc. SunOS 5.8 Generic Patch February 2004
$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Feb 20 13:19:28 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 – Production
In addition, if execute “select * from v$version”
command in sqlplus, the same information may appear.
3. Requirements for oracle general installer version
This installation patch includes one oracle standard installer, version 10.1.0.4. Use this installer instead of the installer in 9.2x version or that under oracle installation directory. This patch is not complete software. Install it on a currently existing Oracle9i version. In other words, it means that former Oracle version 9.2.0.x.x is required.
4. Requirements for system
Operating systems are: Solaris 8, Solaris 9 or Solaris 10.
Oracle version is Oracle9i release 2 (9.2.0.1.0) or later.
The version after installation is 9.2.0.7.0.
Perform the following steps:
1. Download and decompress installation software.
i. Select download software according to the original installation oracle bit.
f 32-bit patch pack is: p4163445_92070_SOLARIS.zip
f 64-bit patch pack is: p4163445_92070_SOLARIS64.zip ii. Do not place the patch in the installation directory and
sub-directory. Create a new directory to place patch pack, for example, Oracle_patch.
iii. The decompressed contents are saved in patch saving directory.
$ unzip p4163445_9207_solaris64.zip
2. Guarantee the establishment of environment parameter ORACLE_HOME and ORACLE_SID is correct.
Login the account as oracle. Confirm the environment parameter set is correct, check result by executing env command.
3. Stop oracle database and relevant process instances.
i. Shutdown the current normal and direct prior-level oracle server instance. Stop all monitoring program, agency and other programs in ORACLE_HOME.
ii. Shutdown oracle example in oracle user account. Run sqlplus /nolog, and link by connect /as sysdba, then execute shutdown command.
iii. Shutdown oracle monitoring method is: Start-up lsnrctl as oracle account, and execute stop command.
Steps before Patch Installation
Chapter 2 Database Installation
Patch installation steps including interactive and non-interactive installation.
Interactive installation: When installing patch in one version, which is not Oracle9i version, installer prompts warning dialog box including the following error message:
There are no patches that need to be applied from the patch set oracle9i patch set 9.2.0.7.0.
Oracle general installer is not allowed to continue this installation process, click OK on dialog, and then click Cancel to exit.
Installation steps are as follows:
1. Login account as oracle.
2. To install patch from telnet installation mode via Xmanager, perform the following actions:
Input the below commands to display direct X applications in local system, and change local_host IP into Xmanager‘s IP address.
% setenv DISPLAY local_host:0.0
3. Input the following commands to start-up installer, which is under patch decompress directory.
cd Oracle_patch/Disk1 ./runInstaller
4. Click Next on Welcome page, File Location window appears.
5. On File Locations page, click Browse and select original file near to Name field in source area.
6. Select products xml file of Disk1/stage under patch decompress directory. For example, this file is:
Oracle_patch/Disk1/stage/products.xml.
7. In Name field of destination area of this page, select Oracle Home directory that need to install patch from drop-down list. Click Next to enter Summary page.
8. Summary page lists all relevant patches and original file.
Click Install.
9. Installation process is interrupted, use root account to execute $ORACLE_HOME/root.sh. At the same time, start another client to login using root account, execute root.sh Patch
Installation Steps
2. Set two initialization parameters: SHARED_POOL_SIZE and JAVA_POOL_SIZE.
Before executing the updated root version catpatch.sql, confirm the two parameter values are not less than 150 MB.
Login as oracle, and start up database:
$ sqlplus “ /as sysdba”
SQL > STARTUP
Check the two parameters.
Note: The unit is byte. 1 MB is equal to 1048576 bytes.
SQL> SHOW PARAMETER SHARED_POOL_SIZE SQL> SHOW PARAMETER JAVA_POOL_SIZE
If the value is less than 157286400, and system uses server parameter file, execute the following commands to modify value:
SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;
Shutdown database:
SQL >shutdown 3. Update database
Login as oracle.
Start up oracle monitor.
$ lsnrctl start
Use SQL*Plus and log in as SYS user.
$ sqlplus /nolog
SQL> CONNECT / AS SYSDBA
Execute the following commands. Use the full path of ORACLE_HOME to replace the part of <?>.
Note: The process may last a long time. Do not terminate it.
The system saves this operation to patch.log.
SQL> STARTUP MIGRATE SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql SQL> SPOOL OFF
Check patch.log file. It includes every server version and status in database. If there is any mistake, modify and
Chapter 2 Database Installation
SQL> STARTUP
Run utlrp.sql root version, and re-edit all invalid PL/SQL packets immediately.
Note: Replace ＜？＞ with ORACLE_HOME path.
SQL> @?/rdbms/admin/utlrp.sql