Steps to Install Oracle 12c Database

Note: Install the database according to the vendor's instructions. Be sure to note the database installation user name and password for use later in the installation process.

 

The Oracle database must use a Unicode character set defined at database creation. Complete the following installation tasks:

Run SQL*Plus

Run SQL*Plus as a user with DBA privileges by running the following command:

sqlplus / as sysdba

Create Users

Create the Oracle users for the OIPA and IVS schemas by entering the following commands from an sqlplus session:

create user <OIPA Username> identified by <OIPA Password>;

grant connect, resource to <OIPA Username>;

grant UNLIMITED TABLESPACE to <OIPA Username>;

create user <IVS Username> identified by <IVS Password>;

grant connect, resource to <IVS Username>;

grant UNLIMITED TABLESPACE to <IVS Username>;

Import the Databases

  1. Create the Oracle directories for the fully qualified path to the export data pump dumpfile. Enter the following commands from a sqlplus session:

create directory oipa_dir as '<fully qualified path holding the dumpfiles>';

-- Example: /opt/oracle/backups/

grant read, write on directory oipa_dir to system;

exit;

  1. Create and load the oipa and IVS databases using import data pump (impdp):

Note: The impdp command can be run interactively. It will prompt you to provide any required arguments not on the command line, or you can enter them in one command. The system password is the same password entered when the database was configured, and the OIPA and IVS Usernames and passwords are those entered in the Create Users section above.

 

impdp system/<system password> directory=oipa_dir dumpfile=oipa_pas.dmp logfile=OIPA_PAS.log full=yes remap_schema=oipa:<OIPA Username>

impdp system/<system password> directory=oipa_dir dumpfile=oipa_ivs.dmp logfile=OIPA_IVS.log full=yes remap_schema=ivs :<IVS Username>

Create a Read-Only Database User

  1. Extract "create_readonly_user.sh" from OIPA distribution.
  2. Mention file will be available at "script\oracle\unix".
  3. Change the permissions so the script can be executed by the shell by entering the following command:

chmod 770 Create_readonly_user.sh

  1. Execute the script by entering the following command:

./create_readonly_user.sh

  1. When prompted you will need to answer the following:
    • SYSTEM password – The password that was set during the configuration of Oracle 11g.

    • Table Owner Userid – Type the OIPA Username used above.

    • Read Only Userid – Type OIPA_RO. You may use this example or create your own user.

    • Read Only Password – Type OIPA_RO. You may use this example or create your own password.

 

 

 

 

 

 

Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us