Início > Oracle > Oracle 11.2.0.3: Alterando nls_parameters NLS_DATE_FORMAT

Oracle 11.2.0.3: Alterando nls_parameters NLS_DATE_FORMAT

Alterando nls_parameters:

[oracle@DBPRD oracle]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 16 13:54:12 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> SELECT INSTANCE_NAME FROM v$instance;

INSTANCE_NAME
—————-
UAT2

SQL> SELECT value FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';

VALUE
—————————————————————
YYYY-MM-DD

SQL> create pfile='/u01/app/oracle/initPROD.ora' from spfile;

SQL> exit;

[oracle@DBPRD oracle]$ vi initPROD.ora

PROD.__db_cache_size=3154116608
PROD.__java_pool_size=16777216
PROD.__large_pool_size=16777216
PROD.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PROD.__pga_aggregate_target=2701131776
PROD.__sga_target=4043309056
PROD.__shared_io_pool_size=0
PROD.__shared_pool_size=788529152
PROD.__streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/admin/PROD/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u02/app/oracle/oradata/PROD/controlfile/o1_mf_8hfld38y_.ctl','/u01/app/oracle/fast_recovery_area/PROD/controlfile/o1_mf_8hfld3bl_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u02/app/oracle/oradata'
*.db_domain='SAOMARTINHO.LOCAL'
*.db_name='PROD'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=63042486272
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODXDB)'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=6744440832
*.open_cursors=300
*.processes=4000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=4405
*.undo_tablespace='UNDOTBS1'
## Add this line bellow
*.nls_date_format='DD/MM/YYYY'

[oracle@DBPRD oracle]$

[oracle@DBPRD oracle]$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 16 13:54:12 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup pfile='/u01/app/oracle/initPROD.ora';
ORACLE instance started.

Total System Global Area 6714322944 bytes
Fixed Size                  2241064 bytes
Variable Size            3539996120 bytes
Database Buffers         3154116608 bytes
Redo Buffers               17969152 bytes
Database mounted.
Database opened.
SQL> select sysdate from dual;

SYSDATE
----------
16/01/2013

SQL> create spfile from 
pfile='/u01/app/oracle/initPROD.ora';

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 6714322944 bytes
Fixed Size                  2241064 bytes
Variable Size            3539996120 bytes
Database Buffers         3154116608 bytes
Redo Buffers               17969152 bytes
Database mounted.
Database opened.
SQL> select sysdate from dual;

SYSDATE
----------
16/01/2013

SQL>
  1. Nenhum comentário ainda.
  1. No trackbacks yet.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s

%d blogueiros gostam disto: