Install Oracle Database
Before you begin
-
Cisco recommends that an Oracle DBA install the Oracle server.
-
You need to update the patch for the known Oracle defect: ORA-22275. If this is not done persistent chat rooms will not work properly.
-
Read the security recommendations for the Oracle database in your Oracle documentation.
-
For information on supported versions, see External Database Setup Requirements.
-
For Oracle version 11 and earlier, you must configure your Oracle database to use UTF8 character encoding.
-
As of Oracle version 12, you must configure the Oracle database to use AL32UTF8 character encoding, as UTF8 may lead to unexpected behavior. For example, if you use UTF8 with Oracle 12, chat rooms may be deleted when you restart the Cisco XCP Text Conference Manager service.
-
To install the Oracle database, refer to your Oracle documentation.
To create tablespace and a database user, connect to the Oracle database as sysdba:
sqlplus / as sysdba
Procedure
Step 1 |
Create tablespace.
|
||||
Step 2 |
Create a database user.
|
||||
Step 3 |
Grant permissions to the database user. The following example grants all permissions to a database user: GRANT DBA TO
user_name;
The following examples grant limited permissions to the database user:
|