Configuring Oracle databases for vCloud Director

Open command prompt on the window system to use oracle SLI.

1. Set Oracle System ID,

C:\Users\Administrator> set ORACLE_SID=orcl

2. To login system as database admin,

C:\Users\Administrator> sqlplus "/as sysdba"

3. When you create the Cloud Director database user account, you must specify CLOUD_DATA as the default tablespace,

Create user $vclouduser identified by $vcloudpass default tablespace CLOUD_DATA;

4. To grant privileges for vCloud user,

SQL> grant CONNECT,RESOURCE,CREATE VIEW, CREATE TRIGGER, CREATE TYPE, CREATE PROCEDURE, CREATE SEQUENCE, CREATE MATERIALIZED VIEW to <user>;


5. The database must be configured to use the AL16UTF16 character set. To check the National Character Set, run the command:

SQL> select * from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';


6. To check the number of configured sessions, run the command:

SQL> show parameter sessions;


References
https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1025768