11G OCM Create REPOS Database


I am now ready to create the REPOS database after having patched the RDBMS software to 11.1.0.7.0.

DBCA

I am extremely lazy by using dbca.

  1. Welcome screen
  2. Operations
    • Create a Database
  3. Database Templates
    • Custom Database
  4. Database Identification
    • repos.gridctrl.yaocm.id.au
    • repos
  5. Management Operation
    • Don’t Configure Enterprise Manager
  6. Database Credentials
  7. Storage Options
    • File System
  8. Database File Locations
    • Use Database File Locations from Template
  9. Recovery Configuration
    • Specify Flash Recovery Area
      • Flash Recovery Area Size = 10GB
    • Enable Archiving
      • Use the defaults
  10. Database Content
    • No Database Components Selected
    • Custom Scripts not changed
    • Standard Database Components
      • Only Oracle XMLDB is selected
        • Placed in SYSAUX
        • Disable XML DB Protocols
  11. Initialization Parameters
    • Memory
      • Typical
      • Memory Size = 806 MB
      • Automatic Memory Management Enabled
    • Sizing
      • Block Size = 8192 Bytes
      • Processes = 150
    • Character Sets
      • Use the default
      • AL16UTF16
      • English
      • Australia
    • Connection Mode
      • Dedicated Server Mode
  12. Security Settings
    • Keep the enhanced 11g default security settings
  13. Automatic Maintenance Tasks
    • Automatic maintenance tasks are disabled because the database instance is not always available
  14. Database Storage
    • Use the defaults
  15. Creation Options
    • Create Database
    • Don’t save as a Database Template
    • Generate Database Creation Scripts into /opt/oracle/app/admin/repos/scripts

Startup Attempt #1

When to use sqlplus / as sysdba, I get the following error:

$ sqlplus / as sysdba
sqlplus: error while loading shared libraries: /opt/oracle/app/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

The setroubleshoot browser says:

SELinux is preventing sqlplus from loading /opt/oracle/app/product/11.1.0/db_1/lib/libnnz11.so which requires text relocation.

Oracle Support search reveals:

./sqlplus: error on libnnz11.so: cannot restore segment prot after reloc [ID 454196.1]

Switch SELinux from the default “Enforcing” mode that it is running in, to the “Permissive” mode.

Commands, as root:
======================
getenforce       (returns "Enforcing")
setenforce 0
getenforce       (returns "Permissive") 	 

Instead, I used SELinux Administration from the System menu to change the enforcing mode to permissive.

Startup Attempt #2

$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Nov 26 19:39:40 2009

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/app/product/11.1.0/db_1/dbs/initREPOS.ora'
SQL> exit
Disconnected

I forgot the simplest thing about ORACLE SIDs – they are CASE SENSITIVE. The database was created as repos while I had set ORACLE_SID to REPOS in

2 thoughts on “11G OCM Create REPOS Database

  1. 11G OCM .bash_profile for GRIDCTRL « Yet Another OCM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s