Oracle Notları

Version bilgisini döndürür

SELECT version FROM v$instance;

Database Create etmeden no mount ile start olalım örnek

startup nomount pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora';

Örnek Database Create

SQL> CREATE DATABASE "orcl"
  2  MAXINSTANCES 8
  3  MAXLOGHISTORY 1
  4  MAXLOGFILES 16
  5  MAXLOGMEMBERS 3
  6  MAXDATAFILES 100
  7  DATAFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  8  EXTENT MANAGEMENT LOCAL
  9  SYSAUX DATAFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
 10  DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
 11  UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
 12  CHARACTER SET WE8ISO8859P15
 13  NATIONAL CHARACTER SET AL16UTF16
 14  LOGFILE GROUP 1 ('/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/redo01.log') SIZE 10240K,
 15  GROUP 2 ('/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/redo02.log') SIZE 10240K,
 16  GROUP 3 ('/u01/app/oracle/product/10.2.0/db_1/dbs/orcl/redo03.log') SIZE 10240K
 17  USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
old  17: USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword"
new  17: USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle"
CREATE DATABASE "orcl"

Default database adı değiştirme
ORA-01103: database name 'ORCL' in control file is not 'DEFAULT'

startup
show parameter db_name
alter system set db_name=ORCL scope=spfile;

Oracle Listener Loglarını Kapatma

vim /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
logging_listener = off