{{parent page="Oracle"}}
===Oracle timezone changes===
%%
srvctl setenv database -d SID -t TZ=Australia/Sydney
%%

=== Create database ===
Creating database should be done with care. Some of the parameters like character set cannot be altered once the database is created. The following example creates a database named 'ora10' with UTF support.

%%
create database ora10
  logfile   group 1 ('D:\oracle\databases\ora10\redo1.log') size 10M,
			group 2 ('D:\oracle\databases\ora10\redo2.log') size 10M,
			group 3 ('D:\oracle\databases\ora10\redo3.log') size 10M
  CHARACTER SET AL32UTF8
  NATIONAL CHARACTER SET AL16UTF16 
  datafile 'D:\oracle\databases\ora10\system.dbf' 
			size 50M
			autoextend on 
			next 10M maxsize unlimited
			extent management local
  sysaux datafile 'D:\oracle\databases\ora10\sysaux.dbf' 
			size 10M
			autoextend on 
			next 10M 
			maxsize unlimited
  undo tablespace undo
			datafile 'D:\oracle\databases\ora10\undo.dbf'
			size 10M
  default temporary tablespace temp
			tempfile 'D:\oracle\databases\ora10\temp.dbf'
			size 10M;
%%

If the database is in English only, change the following parameters.
%%
  character set          WE8ISO8859P1
  national character set utf8
%%

When the database is created, catalog it.
%%
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql    
%%

== Query a database's character set setting ==
%%
select value$ from sys.props$ where name = 'NLS_CHARACTERSET';  
%%

==Query database's process limit==
%%
show parameters PROCESS
%%

==Enable archivelog mode==
%%
SQL> shutdown immediate;
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list;
%%

Then archive logs are automatically stored in DB_RECOVERY_FILE_DEST. One can check where that is by
%%
SQL> show parameters DB_RECOVERY_FILE_DEST;
%%
Which is the $ORACLE_HOME/flash_recovery_area

To immediate archive redo logs
%%
SQL> alter system switch logfile;
SQL> select group#,status,archive from v$log;
SQL> select name from v$archived_log;
%%