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.
-
To install the Oracle database, refer to your Oracle documentation.
Note |
In compliance with XMPP specifications, the IM and Presence Service node uses UTF8 character encoding. This allows the node to operate using many languages simultaneously and to display special language characters correctly in the client interface. If you want to use Oracle with the node, you must configure it to support UTF8. |
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:
|