Jump to: navigation, search

Creating an Oracle 11g Database

This page describes how to create a generic Oracle 11g database. Each individual Oracle database in an Advisors implementation has its own creation script in the 8.5 release.

In 8.5.x releases, all Oracle scripts are creation scripts except those that contain the word migrate in the name. Any existing schema with the same name must be dropped prior to running the scripts. Use the migration scripts when upgrading your software version.

If, due to security restrictions, administrator or security administrator access cannot be granted, the local DBA should implement the steps described in the procedure.

The procedure applies to an Oracle user who has permissions to create tablespaces, users, and to grant permissions. Follow your enterprise’s policies in production environments. If necessary, have the DBA create tablespaces, users, and grant permissions. Use scripts relevant to your environment after the DBA completes the work. Refer to the script content description contained in Advisors Software Distribution Contents.

[+] See recommended database names.


You must perform all the steps in the procedure on a machine where you have Oracle client installed. The installation scripts require SQLPlus which is installed as part of Oracle client installation. Please verify that you have your ORACLE_HOME environment variable and tnsnames.ora content set properly. Verify the connectivity to the instance by running the following command line:
tnsping <alias to the oracle instance contained in the local tnsnames.ora file>

It is important to use <tt><alias to the oracle instance contained in the local tnsnames.ora file> as a response on all prompts where the database scripts ask you to <Enter the database instance alias>.

For example:
Your tnsnames.ora contains the following entry:

wolf =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = inf-wolf.qalab.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.qalab.com)
    )
  )

To check the connectivity type:

C:>tnsping wolf

The successful message will look as follows:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = inf-wolf.qaslab.com)(PORT = 1521)) 
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.qalab.com))) 
OK (0 msec)

1. Copy all of your Oracle database scripts to a folder on the machine where you have the Oracle client installed. The path name for this location must not contain spaces.

2. On the machine where the Oracle client is installed, open a command prompt and change directory to the folder where the database scripts now reside.

3. Review the readme files located in the script directories.
4. Start SQLPlus by entering sqlplus /nolog at the command prompt. You should see the prompt change to SQL>.
SQL Command Prompt
5. Using a user account that has DBA privileges (for example, SYSTEM), connect to the Oracle instance by entering:

conn {User}/{Password}@<alias to the Oracle instance contained in the local your tnsnames.ora file>
at the prompt.

SQL Command Prompt 2
6.
[+] Show steps if required Tablespaces are already present
[+] Show steps if required Tablespaces do not yet exist
This page was last modified on June 19, 2014, at 11:26.

Feedback

Comment on this article:

blog comments powered by Disqus