You can install the Developer database manually by running the scripts provided with the software. If you are using an Oracle Database, a script creates the schema, populates it with the appropriate objects, and creates an application user for the schema. If you are using a Microsoft SQL Server, one script creates the database and the database user, and a second script populates the database with the appropriate objects.


You must have the proper administrative credentials for the database server to create and populate the schema or database.


Note: A Microsoft SQL Server must be configured with mixed mode authentication.

 

To install the database manually on an Oracle Database server:

  1. From the Windows Start menu, open a Command Prompt window.
     
  2. To create the schema using the CreateSchemaObjects.sql script located in \db scripts\ORACLE\Developer in the software installation files, enter the following at the command prompt:
     
    sqlplus - SQL*Plus is the command line application for Oracle Database.
     
    -s - Run SQL*Plus without SQL*Plus messaging.
     
    <adminuser> - The administrative user for the instance of the Oracle server.
     
    <adminpwd>@<instance> - The password for the administrative user and the name of the instance.
     
    <scriptlocation>\<scriptname> - The path to the location of the script and the name of the script to be run.
     
    schema_owner - The schema owner name is limited to 20 characters.
     
    password - This will be the password used for the schema owner account and the schema_app account (this account is created automatically).
     
    tablespace - The name of the tablespace.
     
    tablespace_datafile - The tablespace location plus the name of the tablespace you used in the previous parameter.
     
    Statement with generic parameters:
    sqlplus -s <adminuser>/<adminpwd>@<instance> @"<script location>\<script name>" schema_owner password tablespace tablespace_datafile
     
    Example with default install parameters:
    sqlplus -s system/password@xe @"E:\Setup\db scripts\ORACLE\Developer\CreateSchemaObjects.sql" ODServer password ODDevContent "C:\app\Administrator\oradata\orcl\ODDevContent.DBF"
     
  3. Confirm the parameters and run the script.

To install the database manually on a Microsoft SQL Server:

  1. From the Windows Start menu, open a Command Prompt window.
     
  2. To create the database using the CreateDB.sql script located in \db scripts\MSSQL\Developer in the software installation files, enter the following at the command prompt:
     
    sqlcmd - The command line application for the Microsoft Sequel server.
     
    -E - Use a trusted connection to the Microsoft Sequel server. To use a login and password, use the -U <LOGINID> -P <password> parameters.
     
    -S <servername> - The name of the Microsoft SQL server.
     
    -i "<scriptfile>" - The path to the script file and the name of the script file.
     
    -v DBName="<database name>" - The name of the database to be created.
     
    -v DBPath="<database file location"> - The path to the location where you want to create the database.
     
    Statement with generic parameters:
    sqlcmd -E -S <servername> -i <scriptfile> –v DBName="<VALUE1>" -v DBPath="<VALUE2>"
     
    Example with default install parameters:
    sqlcmd -E -S "mysqlserver" -i "E:\Setup\db scripts\MSSQL\Developer\CreateDB.sql" -v DBName="ODDevContent" -v DBPath="C:\database"
     
  3. Confirm the parameters and run the script.
     
  4. To create the database objects using the CreateDBObjects.sql script located in \db scripts\MSSQL\Developer in the software installation files, enter the following at the command prompt:
     
    -E - Use a trusted connection to the Microsoft Sequel server. To use a login and password, use the -U <LOGINID> -P <password> parameters.
     
    -S <servername> - The name of the Microsoft SQL server.
     
    -i "<scriptfile>" - The path to the script file and the name of the script file.
     
    -v DBOwner="<owner name>" - The database account that will own the database. If the account does not exist, it will be created.
     
    -v Password="<Password"> - The password for the database owner account.
     
    -v DBName="<database name>" - The name of the database created in the previous script.
     
    Statement with generic parameters:
    sqlcmd -E -S <servername> -i <scriptfile> -v DBOwner="<VALUE1>" -v Password="<Value2>" –v DBName="<VALUE3>"
     
    Example with default install parameters:
    sqlcmd -E -S "mysqlserver" -i "E:\Setup\db scripts\MSSQL\Developer\CreateDBObjects.sql" -v DBOwner="ODServer" -v Password="password" -v DBName="ODDevContent"
     
  5. Confirm the parameters and run the script.
     
  6. Close the Command Prompt window.

Table of Contents