Recommendations for Oracle Database

The following settings are recommended for Oracle database:

Notes:

• If you are not familiar with accessing or administering pluggable databases, Oracle recommends installing Oracle 12C without pluggable database.
• When you attempt to create a database using Oracle Database 12c, the option to create a pluggable database will be enabled by default. If you do not want to create a container database, deselect the Create As Container Database check box during the database creation process. If you create a container database, you must also create a pluggable database on which to install your EnterpriseTrack instance.

Character Set Recommendations

For Unicode national language support, the NLS_CHARACTERSET should be set to AL32UTF8 while creating the database. Review this with your database administrator before adapting and implementing it to your environment.

Check the character set by using the following syntax:

SQL> select name, value$ from sys.props$ where name = 'NLS_CHARACTERSET';

This should return AL32UTF8.

Byte Length Semantics

Check for byte length semantics using the following syntax:

SQL> select name, value$ from sys.props$ where name = 'NLS_LENGTH_SEMANTICS';

This should return BYTE.