...

Configure the Oracle Database

...

The following steps will need to be followed:

• Step 1: After installation, Set Collation and DB Parameters
  
• Step 2: Setup your database charset
  
• Step 3: Connect in SQL Developer

Anchor
step1 step1

Step 1: After installation, Set Collation and DB Parameters:

Default collation is Binary for Oracle and the one that is supported. The following query can be used to validate the collation for the user(database)

...

SELECT * FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET%';

...

Anchor
step2 step2

Step 2: Setup your database charset:

1. shutdown immediate;
2. startup restrict;
3. select name from v$database;

4. view code below:

   Code Block
   language sql theme Emacs
   ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;

   
   

5. view code below:

   Code Block
   language sql theme Emacs
   SELECT value FROM NLS_DATABASE_PARAMETERS WHERE parameter=’NLS_CHARACTERSET’;

   
   

6. shutdown immediate;
7. startup;

Anchor
step3 step3

Step 3: Connect in SQL Developer:

Run Below Command for User creation:

...

SELECT * FROM DBA_DATA_FILES;
ALTER DATABASE DATAFILE '<example>/u01/app/oracle/oradata/XE/system.dbf<example>' AUTOEXTEND ON MAXSIZE UNLIMITED;

Back to Top ^