You can choose to create the schema only without installing the Developer Server software. This allows you to create the schema on a dedicated server, and then install the Developer Server software on another server. If you choose to do this, you must create the schema before you install the Developer Server software. You must have the proper administrative credentials for the database server to create and populate the schema or database.
To create an Oracle schema with all the objects, two scripts must be run. One script, CreateSystemObjects, requires system administrator privileges. It creates the tablespace, the schema owner and the application user schema that has access to the schema where the Developer objects are created. The second script, CreateSchemaObjects, creates the schema objects necessary to run Developer. This script should be run by the schema owner account created from the CreateSystemObjects script.
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. The SQL scripts are intended to be run by an SQL administrator with either sysadmin or a combination of securityadmin and dbcreator privileges. The database objects creation does not necessarily require these privileges and could be performed by the user with db_owner privileges for the database. This would require modifications to the SQL scripts.
The second set of credentials is used for the Web Services access for the Developer to read from and write to the database. This can be a pre-existing login, for which you must supply the correct login name and password, or you can specify a new login name and password. The installer grants this account access to the database and adds it to the appropriate roles.
Note: A Microsoft SQL Server must be configured with mixed mode authentication.
To install the database manually on an Oracle Database server:
From the Windows Start menu, open a Command Prompt window.
To create the schema using the CreateSystemObjects.sql script located in \db scripts\ORACLE\Developer in the software installation files, enter the following at the command prompt:
The variables that need to be replaced are:
<ORACLE_ADMINISTRATOR> - administrator user login with credentials to create tablespace, user, and so on.
<ORACLE_ADMINISTRATOR_PASSWORD> - password for the Oracle administrator
<SERVER_INSTANCE> - name of the Oracle server instance where the tablespace and users will be created
<SCHEMA_OWNER> - user to be created that is the schema owner
<SCHEMA_OWNER_PASSWORD> - password to be set for the schema owner
<TABLESPACE_NAME> - the name of the tablespace to be created that will contain the schema
<TABLESPACE_DATA_FILE> - the full path (with file name) to the tablespace file (the DBF file to be created)
<SCHEMA_USER> - the application user that is create to have access to the Developer schema
<SCHEMA_USER_PASSWORD> - password to be set for the application user with access to the Developer schema
Example with default install parameters:
sqlplus -s system/password@xe @"E:\Setup\db scripts\ORACLE\Developer\CreateSystemObjects.sql" ODServer password ODDevContent "C:\app\Administrator\oradata\orcl\ODDevContent.DBF" ODServer_app password
Confirm the parameters and run the script. After the schema is created, enter exit and press ENTER to return to the prompt in the Command Prompt window.
Next create the schema objects by running the CreateSchemaObjects.sql script. The script contains variables that are replaced with the text supplied for the values.
Warning! The values must be in this order to run correctly. Standard SQL*Plus syntax:
sqlplus -s <SCHEMA_OWNER>/<SCHEMA_OWNER_PASSWORD>@<SERVER_INSTANCE> @"<SCRIPT_LOCATION>\<SCRIPT_NAME>" variable_value1 variable_value2 ... variable_valueN Note: The -s parameter runs SQL*Plus without SQL*Plus messaging.
Run the following: sqlplus -s <SCHEMA_OWNER>/<SCHEMA_OWNER_PASSWORD>@<SERVER_INSTANCE> @"CreateSchemaObjects.sql" <SCHEMA_OWNER> <SCHEMA_USER>
The variables that need to be replaced are: <SCHEMA_OWNER> - user created that is the schema owner
<SCHEMA_OWNER_PASSWORD> - password set for the schema owner
<SERVER_INSTANCE> - name of the Oracle server instance where the tablespace and users are created
<SCHEMA_OWNER> - user created that is the schema owner
<SCHEMA_USER> - the application user that has access to the Developer schema Example with default install parameters:
sqlplus -s ODServer/password@xe @"E:\setup\db scripts\ORACLE\Developer\CreateSchemaObjects.sql" ODServer ODServer_app
Confirm the parameters and run the script. After the script runs, enter exit and press ENTER to return to the prompt in the Command Prompt window.
Enter exit and press ENTER to exit the Command Prompt window.
To install the database manually on a Microsoft SQL Server:
From the Windows Start menu, open a Command Prompt window.
First create the database using the CreateDB.sql script. The script contains variables that are replaced with the text supplied for the values.
Warning! All variable names must be referenced for the script to run successfully.
Note: The -E parameter means use an entrusted connection to the SQL Server. To use a login and password, use -U <LOGINID> and -P <PASSWORD> parameters.
Run the following:
sqlcmd -E -S <SERVER_NAME> -i CreateDB.sql -v DBName="<DATABASE_NAME>" -v DBPath="<DATABASE_FILE_LOCATION>"
The variables that need to be replaced are:
<SERVER_NAME> - the server instance to connect to
<DATABASE_NAME> - the name of the database to be created that contains the tables, procedures, etc.
<DATABASE_FILE_LOCATION> - the path (without file name) to the database file folder (where the MDF and LDF files will be created).
Enter the fully qualified path of the script file. The initial size of the database will be 500 MB with the database log size of 125MB.
Example with default install parameters:
sqlcmd -E -S "sqlserver" -i "E:\Setup\db scripts\MSSQL\Developer\CreateDB.sql" -v DBName="ODDevContent" -v DBPath="C:\database"
Confirm the parameters and run the script.
Create the database objects by running the CreateDBObjects.sql script. The script contains variables that are replaced with the text supplied for the values.
Warning! All variable names must be referenced for the script to run successfully.
Standard sqlcmd syntax:
sqlcmd -E -S <SERVER_NAME> -i <SCRIPTFILE> –v VARIABLE1="<VALUE1>" -v VARIABLE2="<VALUE2>" Note: The -E parameter means use an entrusted connection to the SQL Server. To use a login and password, use -U <LOGINID> and -P <PASSWORD> parameters.
Run the following: sqlcmd -E -S <SERVER_NAME> -i CreateDBObjects.sql -v DBOwner="<DATABASE_OWNER>" -v Password="<DATABASE_OWNER_PASSWORD>" -v DBName="<DATABASE_NAME>"
The variables that need to be replaced are: <SERVER_NAME> - the server instance to connect to
<DATABASE_OWNER> - database user to be created that is the primary owner of the database
<DATABASE_OWNER_PASSWORD> - password to be set for the database owner
<DATABASE_NAME> - the name of the database to be updated
Enter the fully qualified path of the script file.
Example with default install parameters:
sqlcmd -E -S "sqlserver" -i "E:\Setup\db scripts\MSSQL\Developer\CreateDBObjects.sql" -v DBOwner="ODServer" -v Password="password" -v DBName="ODDevContent"
Confirm the parameters and run the script.
Enter exit and press ENTER to exit the Command Prompt window.
To install the database manually on an Oracle Database server: