Oracle DBA Tips and Techniques



On LINUX X86 64 BITDownload foll files from :1. 11g Rel 2 for LINUX.1. linux.x64_11gR2_database_1of22. linux.x64_11gR2_database_2of22. 12c Cloud Control - Enterprise Manager.1. em12_linux64_disk1of22. em12_linux64_disk2of2Copy both sets of zip files into separate directories on linux server and unzip them.Begin installation1. Install 11g rel2 Linux software.2. Create database using 11g rel2 Linux softwareBefore creating database, make sure /etc/hosts file has name of host :Otherwise dbca database creation will fail with:ORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=cloud.control)(PORT=1521))Hostname[oracle@cloud oradata]$ hostnamecloud.control [oracle@cloud flash_recovery_area]$ cat /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost::1 localhost6.localdomain6 localhost610.254.8.200 cloud.control cloud[oracle@cloud flash_recovery_area]$Also make sure ulimit –n is unlimited.[oracle@cloud bin]$ ulimit -n1024[oracle@cloud bin]$Get unix to change it to unlimited or 4096.Once database is created , remove the dbcontrol repository created by dbca for enterprise manager.emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys pasword> -SYSMAN_PWD <sysman password>emca -deconfig dbcontrol db -repos drop -SYS_PWD oracle12c -SYSMAN_PWD oracle12cALTER SYSTEM SET processes=300 SCOPE=SPFILE;ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;Shutdown immediate;Startup;2. Cloud Control installation.Create directory to hold Middleware ( Web Logic,etc)cd /home/oraclemkdir Middlewarecd /home/oracle/stage[oracle@cloud stage]$ export DISPLAY=10.254.101.208:0.0 [oracle@cloud stage]$ ./runInstallerStarting Oracle Universal Installer...Checking Temp space: must be greater than 400 MB. Actual 98300 MB PassedChecking swap space: must be greater than 150 MB. Actual 5951 MB PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-09_10-59-46AM. Please wait ...[oracle@cloud stage]$Click on warning row and ignoreClick OK and then IgnoreNote down the administrator passwords.lefttopCarry out checks Agent checkscd /home/oracle/Middleware/agent/agent_inst/bin./emctl status agent[oracle@cloud bin]$ ./emctl status agentOracle Enterprise Manager 12c Cloud Control 12.1.0.1.0Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.---------------------------------------------------------------Agent Version : 12.1.0.1.0OMS Version : 12.1.0.1.0Protocol Version : 12.1.0.1.0Agent Home : /home/oracle/Middleware/agent/agent_instAgent Binaries : /home/oracle/Middleware/agent/core/12.1.0.1.0Agent Process ID : 11855Parent Process ID : 11783Agent URL : URL : at : 2011-12-12 11:24:29Started by user : oracleLast Reload : (none)Last successful upload : 2011-12-12 13:03:22Last attempted upload : 2011-12-12 13:03:22Total Megabytes of XML files uploaded so far : 1.45Number of XML files pending upload : 0Size of XML files pending upload(MB) : 0Available disk space on upload filesystem : 70.67%Collection Status : Collections enabledLast attempted heartbeat to OMS : 2011-12-12 13:04:53Last successful heartbeat to OMS : 2011-12-12 13:04:53---------------------------------------------------------------Agent is Running and Ready[oracle@cloud bin]$ pwd/home/oracle/Middleware/agent/agent_inst/bin[oracle@cloud bin]$ ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download