Oracle 12c Install & Config


        

Oracle Enterprise Manager Cloud Control 12c Release 1 Installation on Oracle Linux 5.7(x86_64)

 

Install the oracle 11.2.0.3 Database

The following packages are necessary for the cloud control Installations

# OL 5.x
make‐3*
binutils‐2*
gcc‐4*
libaio‐0*
glibc‐common‐2*
libstdc++‐4*
sysstat‐5*

If you have performed a default database installation you will need to deconfigure Enterprise Manager Database Control. Run the following command as the “oracle” user

.

[oracle@oracle ~]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Aug 19, 2015 5:01:02 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
———————————————————————-
WARNING : While repository is dropped the database will be put in quiesce mode.
———————————————————————-

Do you wish to continue? [yes(Y)/no(N)]: y
Aug 19, 2015 5:01:15 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2015_08_19_17_01_01.log.

Aug 19, 2015 5:01:16 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Aug 19, 2015 5:01:16 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed

Aug 19, 2015 5:01:16 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:

1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script

2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script

Aug 19, 2015 5:01:16 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) …

Aug 19, 2015 5:01:16 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 19, 2015 5:01:16 PM

Make the following initialization parameter changes and restart the instance

SQL> ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
System altered.

ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
System altered.

ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
System altered.

ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
System altered.

SQL> ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
System altered.

ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
System altered.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area        2137886720 bytes
Fixed Size                                   2230072 bytes
Variable Size                               671090888 bytes
Database Buffers                        1459617792 bytes
Redo Buffers                               4947968 bytes
Database mounted.
Database opened.

If you have done a default installation as described here, the UNDO tablespace will be autoextensible. If you have done a custom installation make sure the UNDO tablespace is at least 200M in size

.

SQL>ALTER TABLESPACE UNDOTBS ADD DATAFILE  ‘/u01/app/oracle/oradata/orcl/undo02.dbf’ size 200m autoextend on;

Database altered.

Make sure you have 3 redo logs of at least 300M to prevent a warning during the installation

SQL> alter database add logfile group 3‘/u01/app/oracle/oradata/orcl/redo03.log’ size 200m;
Database altered

Cloud Control 12c Installation

Make a directory to hold the Middleware installation.

[oracle@oracle ~]$ mkdir -p /u01/app/oracle/middleware

Unzip the Cloud Control media, the start the installation by running the “runInstller” script.

[oracle@oracle ~]$ unzip em12_linux64_disk1of3.zip
[oracle@oracle ~]$ unzip em12_linux64_disk2of3.zip
[oracle@oracle ~]$ unzip em12_linux64_disk3of3.zip
[oracle@oracle ~]$./runInstaller

1

2

3

4

5

6

7

8

9

10

11

12

No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *