Oracle 12c Enterprise Manager Cloud Control Installation on Oracle Linux 6

Download Software 
--------------------

http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html?ssSourceSiteId=ocomen

Check the HOST NAME in hosts file.

# /etc/hosts

 192.0.0.24    rac1 

# /etc/sysconfig/network

HOSTNAME: rac1


Installed Oracle Database 11g


Cloud Control 12c Installation

---------------------------------------------------

Make the following directories to hold the management server and agent.

$mkdir -p /ora/oracle/middle

$mkdir -p /ora/oracle/agent

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

$ mkdir /ora/oracle/em12c

$ unzip -d /ora/oracle/em12c em12cr2_linux64_disk1.zip

$ unzip -d /ora/oracle/em12c em12cr2_linux64_disk2.zip

$ unzip -d /ora/oracle/em12c em12cr2_linux64_disk3.zip

$ ./runInstaller

(https://rac1:7803/em). Log in with the username "sysman" and the password you specified during your installation.

 

"License Agreement" screen. Click the "I Agree" button and you are presented with 

the homepage selector  screen. Select the desired homepage (I chose Summary)

and click the "Preview" button.

# !/bin/bash

export ORACLE_HOME=/ora/oracle/ora11g
export OMS_HOME=/ora/oracle/middle/oms
export AGENT_HOME=/ora/oracle/middleware/agent/core/12.1.0.1.0


Starting Everything:
--------------------

$ OMS_HOME/bin/emctl start oms -all

$ AGENT_HOME=/bin/emctl start agent

$ ORACLE_HOME/bin/dbstart  $ORACLE_HOME

Stopped Everything:
--------------------

$ OMS_HOME/bin/emctl stop oms -all

$ AGENT_HOME=/bin/emctl stop agent

$ ORACLE_HOME/bin/dbshut $ORACLE_HOME

ORA-01034: ORACLE not available & ORA-00838: Specified value of MEMORY_TARG

bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Sat Nov  02 18:53:58 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn / as sysdba

Connected.

SQL> alter system set sga_target=2G scope=SPFILE;

System altered.

SQL> ALTER SYSTEM SET session_cached_cursors=200 scope=spfile;

System altered.

SQL> alter system set processes=300 scope=spfile;

System altered.

SQL> alter system set shared_pool_size=600m scope=spfile;

System altered.

SQL> alter system set pga_aggregate_target=1g scope=spfile;

System altered.

SQL> alter system set open_cursors=300 scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3072M

SQL> create pfile from spfile;

File created.

Change the value of MEMORY_TARGET parameter.

$ vi /ora/oracle/dbs/initcdb1.ora

MEMORY_TARGET=0

bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Sat Nov  02 19:53:58 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='/ora/oracle/dbs/initcdb1.ora';
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size    2290416 bytes
Variable Size  805309712 bytes
Database Buffers 1325400064 bytes
Redo Buffers    4886528 bytes
Database mounted.
Database opened.

Connect to a PDB using Oracle EM Express

Configuring the HTTPS Port for EM Database Express 12c


bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.1.0 Production on Thu Sep 5 22:28:38 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.



SQL> conn / as sysdba
Connected.

SQL> select dbms_xdb_config.gethttpsport() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
---------------------------------------------------------------


SQL> exec dbms_xdb_config.sethttpsport(5501);

PL/SQL procedure successfully completed.


SQL> select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT
--------------------------
5501

PRVF-0002 : Could not retrieve local nodename

Installing Oracle 12c database getting below error.

Cause: Unable to determine local host name using Java network functions. 
Action: Ensure hostname is defined correctly using the 'hostname' command.




 # hostname

ora12c.localdomain

Add the hostname into /etc/hosts

# vi /etc/hosts

192.0.0.25   ora12c.localdomain

Oracle 12c Database Installation on Virtual Box

Environment:

Oracle 12c  Database
Virtual Box 4
Oracle Linux 6

unzip /tmp/linuxamd64_12c_database_1of2.zip -d /u01/app/oracle/software
unzip /tmp/linuxamd64_12c_database_2of2.zip -d /u01/app/oracle/software

Restore SQL Server 2012 Database on Windows Server 2012

Restore SQL Server 2012 Database using SQL Server Management Studio.

Installing NetFx3 on Windows Server 2012

Installing SQL Server 2012 on a Windows Server 2012 virtual machine, and the installation was already in progress when we received the following error: