Oracle database configuration requirements
The users who can configure Oracle must have permissions and access as required and be familiar with Oracle and Microsoft environments.
All implicit steps that must be done were considered for inclusion in these procedures. The procedures were written for administrators who have knowledge of the Oracle and Microsoft environments.
Please be sure that you satisfy the following before beginning:
- A DBA role is required for a database migration.
- A server reboot is required after Oracle installation to make sure that all Oracle environment settings are available to you.
- Settings should be
NLS CHARACTERSET=UTF8,NLS_LENGTH_SEMANTICS=CHARandNLS_NCHAR_CHARACTERSET=AL16UTF16.
Also note:
- Executed actions should be done in the same command window so settings which are shell specific, for example,
ORACLE_SIDorORACLE_HOMEare available. - All paths are examples only. Paths are system specific, so make sure that all file paths are valid and contain the correct file(s), and beware of read-only flags on files.
- The default database name is ISH and is used in examples in the procedures.