db_name='GATEWAY'
memory_target=1G
processes = 150
audit_file_dest='/oradata/db11g/audit'
audit_trail ='db'
db_block_size=8192
db_domain='nbg.com.cy'
db_recovery_file_dest='/oradata/db11g/flash_recovery_area'
db_recovery_file_dest_size=100G
diagnostic_dest='/oradata/db11g/diag'
dispatchers='(PROTOCOL=TCP) (SERVICE=GATEWAYXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = ('/oradata/db11g/databases/GATEWAY/control1.ctl','/oradata/db11g/databases/GATEWAY/control1.ctl')
compatible ='11.2.0'
aq_tm_processes=1
sessions=400
db_file_multiblock_read_count=16
----------------------------------------------------------------------------------------------------------------------------
orapwd FILE=/oradata/db11g/product/11.2.0/dbhome_1/dbs/orapwGATEWAY ENTRIES=10
----------------------------------------------------------------------------------------------------------------------------
export ORACLE_SID=GATEWAY
----------------------------------------------------------------------------------------------------------------------------
CREATE DATABASE GATEWAY
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/oradata/db11g/databases/GATEWAY/redo01.log') SIZE 50M,
GROUP 2 ('/oradata/db11g/databases/GATEWAY/redo02.log') SIZE 50M,
GROUP 3 ('/oradata/db11g/databases/GATEWAY/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET EL8ISO8859P7
NATIONAL CHARACTER SET UTF8
EXTENT MANAGEMENT LOCAL
DATAFILE '/oradata/db11g/databases/GATEWAY/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/oradata/db11g/databases/GATEWAY/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/oradata/db11g/databases/GATEWAY/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/oradata/db11g/databases/GATEWAY/temp01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 4096M
UNDO TABLESPACE UNDOTBS1
DATAFILE '/oradata/db11g/databases/GATEWAY/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE 4096M;
----------------------------------------------------------------------------------------------------------------------------
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
-----------------------------------------------------------------------------------------------------------------------------
CREATE TABLESPACE CHASER_TBS LOGGING
DATAFILE '/oradata/db11g/databases/GATEWAY/chaser_tbs01.dbf'
SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 4096M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
-----------------------------------------------------------------------------------------------------------------------------
