Criar Instância sem usar modo gráfico

[David SiqueiraParticipante]

Opa!!!..e ai carinha tudo bem, se você estiver precisando apenas dos comandos de create database ai vai :

connect “SYS”/”&&sysPassword” as SYSDBA
set echo on
spool /u01/app/oracle/admin//scripts/CreateDB.log
startup nomount pfile=”/u01/app/oracle/admin//scripts/init.ora”;
CREATE DATABASE “”
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE ‘/u02/oracle/oradata//system01.dbf’ SIZE 2000M REUSE AUTOEXTEND ON
NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE ‘/u02/oracle/oradata//sysaux01.dbf’ SIZE 1000M REUSE AUTOEXT
END ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE ‘/u02/oracle/oradata//t
emp01.dbf’ SIZE 500M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE “UNDOTBS1” DATAFILE ‘/u02/oracle/oradata//undotbs0
1.dbf’ SIZE 1000M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 (‘/u02/oracle/oradata//redo01a.log’, ‘/u01/app/oracle/oradat
a//redo01b.log’) SIZE 100M,
GROUP 2 (‘/u01/app/oracle/oradata//redo02a.log’, ‘/u02/oracle/oradata//redo02b.log’) SIZE 10
0M,
GROUP 3 (‘/u02/oracle/oradata//redo03a.log’, ‘/u01/app/oracle/oradata//redo03b.log’) SIZE 10
0M,
GROUP 4 (‘/u01/app/oracle/oradata//redo04a.log’, ‘/u02/oracle/oradata//redo04b.log’) SIZE 10
0M,
GROUP 5 (‘/u02/oracle/oradata//redo05a.log’, ‘/u01/app/oracle/oradata//redo05b.log’) SIZE 10
0M,
GROUP 6 (‘/u01/app/oracle/oradata//redo06a.log’, ‘/u02/oracle/oradata//redo06b.log’) SIZE 10
0M
USER SYS IDENTIFIED BY “&&sysPassword” USER SYSTEM IDENTIFIED BY “&&systemPassword”;
spool off

Obs.: Não se esqueça de antes preparar o Init.ora com os seus parametros, depois ou antes também, preparar seu arquivo LISTENER.ORA com seus parametros de configuração.

Espero ter ajudado.