public
Created

comando uteis para config do oracle

  • Download Gist
gistfile1.txt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
Comandos uteis do oracle para obter configiurações:
Parâmetros da NLS:
=> Select * from nls_database_parameters
=> Select * from nls_session_parameters
=> Select * from nls_instance_parameters
 
Exibe os valores de database_parameters
=> SELECT name,value$ from sys.props$ where name like '%NLS_LANG%'
=> SELECT name,value$ from sys.props$ where name like '%NLS_CHAR%'
=> SELECT name,value$ from sys.props$ where name like '%_CHARACTER%'
=> Select nls_charset_id('WE8MSWIN1252') from dual
=> Select nls_charset_name(178) from dual
 
Para se alterar os valores das configurações da NLS temos os seguintes comandos:
 
=> Alter Session Set NLS_LANGUAGE = "PORTUGUESE"
=> Alter Session Set NLS_TERRITORY = "BRAZIL"
=> Alter System Set NLS_LANGUAGE='BRAZILIAN PORTUGUESE' scope=spfile;
=> Alter System Set NLS_TERRITORY='BRAZIL' SCOPE=SPFILE;
=> Update sys.props$ set value$ = 'WE8MSWIN1252' where name = 'NLS_NCHAR_CHARACTERSET';
=> Update sys.props$ set value$ = 'WE8MSWIN1252' where name = 'NLS_CHARACTERSET';
 
 
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 AL32UTF8;
shutdown immediate;
startup restrict;
shutdown immediate;
startup;
 
maiores esclarecimento no link
http://tosemopcao.blogspot.com.br/2009/11/bd-oracle-acentos-no-10g-xe.html

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.