makaleler / Veritabanı / Oracle Notları

Oracle Notları

17.03.2013 20:52:59

Oracle Notları ve İpuclarını bu sayfadan takip edebilirsiniz.

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

yazar husonet

Yorumlar

Bu içerik için sizde yorum yapabilirsiniz!
anasayfa | makaleler | haberler | dosyalar | linkler | hakkımızda