Here are some common issues in troubleshooting an Oracle Content Store creation.
A) JDBC driver(classes12.jar) has not been been copied from ORACLE_HOME/jdbc/lib to <C8_CRN_location>/webapps/p2pd/WEB-INF/lib. Ensure the 32-bit JDBC driver of the correct version and being used.
B) In SQL Plus, determine if the database is Unicode by typing the following Select statement:
1. Open SQL Plus
2. Issue the following command: select * from NLS_DATABASE_PARAMETERS;
3. Make sure the NLS_CHARACTERSET is one of the following: {UTF-8 or UTF-16, or AL32UTF8 or ALI6UTF16, or not unicode}. If the result set returns
an NLS_CHARACTERSET that is not Unicode, create a new database and specify AL32UTF8 or UTF-8 for the database character set parameters.
4. If the character set is different, create a new Oracle instance with the correct character set.
C) Ensure that the user account that accesses the database has permission to do the following:
connect to the database
create, alter, and drop tables
create, alter, and drop triggers
create, alter, and dropviews
create, alter, and drop procedures
create, alter, and drop sequences
