Alterando o CHARACTER do Oracle

Nesse post vamos altera o CHARACTER  do banco de dados Oracle.

 

conn / as sysdba
sho parameter CLUSTER_DATABASE
sho parameter PARALLEL_SERVER
2. Execute the following commands in sqlplus connected as "/ AS SYSDBA":

conn / as sysdba

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE WE8ISO8859P1;
SHUTDOWN IMMEDIATE;

 

 

Cuidado..valide bem antes antes de fazer isso..