{"id":72,"date":"2015-04-06T21:20:00","date_gmt":"2015-04-07T00:20:00","guid":{"rendered":"http:\/\/maxoracle.com\/2015\/04\/06\/criando-o-banco-de-dados-oracle-via-linha-de-comando-countdown-to-ocm\/"},"modified":"2015-04-06T21:20:00","modified_gmt":"2015-04-07T00:20:00","slug":"criando-o-banco-de-dados-oracle-via-linha-de-comando-countdown-to-ocm","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=72","title":{"rendered":"Criando o banco de dados Oracle via linha de comando – Countdown to OCM"},"content":{"rendered":"

Iremos criar um banco de dados Oracle a partir da linha de comando, sem uso de ferramentas.<\/code><\/p>\n

<\/div>\n
Para isso, faremos a divis\u00e3o das etapas em passos mostrados abaixo:<\/div>\n
1) Alterar o \/etc\/oratab adicionando seu novo banco -bash-3.2$ <\/code><\/div>\n
<\/code><\/p>\n
-bash-3.2$ cat \/etc\/oratab<\/span><\/code><\/div>\n

<\/code><\/p>\n

#<\/code><\/div>\n

<\/code><\/p>\n

<\/span><\/code><\/div>\n

<\/p>\n

<\/span><\/div>\n
# This file is used by ORACLE utilities.  It is created by root.sh<\/span><\/div>\n
# and updated by either Database Configuration Assistant while creating<\/span><\/div>\n
# a database or ASM Configuration Assistant while creating ASM instance.<\/span><\/div>\n
<\/span><\/div>\n
# A colon, ':', is used as the field terminator.  A new line terminates<\/span><\/div>\n
# the entry.  Lines beginning with a pound sign, '#', are comments.<\/span><\/div>\n
#<\/span><\/div>\n
# Entries are of the form:<\/span><\/div>\n
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:<\/span><\/div>\n
#<\/span><\/div>\n
# The first and second fields are the system identifier and home<\/span><\/div>\n
# directory of the database respectively.  The third filed indicates<\/span><\/div>\n
# to the dbstart utility that the database should , \"Y\", or should not,<\/span><\/div>\n
# \"N\", be brought up at system boot time.<\/span><\/div>\n
#<\/span><\/div>\n
# Multiple entries with the same $ORACLE_SID are not allowed.<\/span><\/div>\n
#<\/span><\/div>\n
#<\/span><\/div>\n
+ASM:\/u01\/app\/oracle\/product\/11.2.0\/grid:N<\/span><\/div>\n
*:\/u01\/app\/oracle\/agent11g:N<\/span><\/div>\n
PROD1:\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1:N # adicionado <\/div>\n

<\/code><\/div>\n

<\/div>\n
<\/code> 2) Criar os apelidos para os devidos locais, isso facilita a administracao. Arquivo alias.sh<\/div>\n
<\/div>\n
\n
alias tns=’cd $ORACLE_HOME\/network\/admin’<\/span><\/div>\n
alias dbs=’cd $ORACLE_HOME\/dbs’<\/span><\/div>\n
alias startup=’echo startup | sqlplus “\/ as sysdba”‘<\/span><\/div>\n
alias abort=’echo shutdown abort | sqlplus “\/ as sysdba”‘<\/span><\/div>\n
alias mount=’echo startup mount| echo shutdown abort | sqlplus “\/ as sysdba”‘<\/span><\/div>\n
alias rman=’rman target \/’<\/span><\/div>\n
alias rmana=’rman target \/ auxiliary sys\/oracle_4U@aux’<\/span><\/div>\n
alias rdbms=’cd $ORACLE_HOME\/rdbms\/admin’<\/span><\/div>\n<\/div>\n
<\/div>\n
depois de criado, faca a carga do arquivo<\/div>\n
<\/div>\n
source alias.sh<\/div>\n
<\/div>\n
<\/div>\n
 3) Criar o arquivo de senha <\/div>\n
<\/div>\n
\n
-bash-3.2$ dbs<\/span><\/div>\n
-bash-3.2$ pwd<\/span><\/div>\n
\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs<\/span><\/div>\n
-bash-3.2$ orapwd file=orapwPROD1 password=oracle<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n
 4) Criar o arquivo de inicializacao, parameter file  <\/div>\n
<\/div>\n
vi initPROD1.ora<\/div>\n
<\/div>\n
\n
db_name<\/span>=PROD1<\/span><\/div>\n
db_create_file_dest=’\/u01\/app\/<\/span>oracle<\/span>\/oradata\/’<\/span><\/div>\n
db_create_online_log_dest_1=’\/u01\/app\/<\/span>oracle<\/span>\/oradata\/’<\/span><\/div>\n
db_create_online_log_dest_2=’\/u02\/app\/<\/span>oracle<\/span>\/oradata\/’<\/span><\/div>\n
sga_target=1G<\/span><\/div>\n
pga_aggregate_target=200M<\/span><\/div>\n
remote_login_passwordfile<\/span>=’EXCLUSIVE’<\/span><\/div>\n
<\/div>\n
control_files<\/span>=’\/u01\/app\/<\/span>oracle<\/span>\/oradata\/PROD1\/control01.ctl’,’\/u02\/app\/<\/span>oracle<\/span>\/oradata\/PROD1\/control02.ctl’<\/span><\/div>\n

<\/span><\/div>\n

<\/span><\/div>\n
<\/span><\/div>\n
 7) Criar as pastas para o controlfile<\/div>\n<\/div>\n
<\/div>\n
\n
-bash-3.2$ mkdir -p \/u01\/app\/oracle\/oradata\/PROD1\/<\/span><\/div>\n
<\/span><\/div>\n
-bash-3.2$ mkdir -p \/u02\/app\/oracle\/oradata\/PROD1\/<\/span><\/div>\n<\/div>\n
<\/div>\n
 6) Inicializar a instancia, e criar o arquivo spfile <\/div>\n
<\/div>\n
\n
-bash-3.2$ sqlplus \/ as sysdba<\/span><\/div>\n
<\/span><\/div>\n
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 6 21:45:22 2015<\/span><\/div>\n
<\/span><\/div>\n
Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span><\/div>\n
<\/span><\/div>\n
Connected to an idle instance.<\/span><\/div>\n
<\/span><\/div>\n
SQL> startup<\/span><\/div>\n
ORACLE instance started.<\/span><\/div>\n
<\/span><\/div>\n
Total System Global Area 1071333376 bytes<\/span><\/div>\n
Fixed Size <\/span> <\/span>    1349732 bytes<\/span><\/div>\n
Variable Size <\/span> <\/span>  281020316 bytes<\/span><\/div>\n
Database Buffers <\/span>  784334848 bytes<\/span><\/div>\n
Redo Buffers <\/span> <\/span>    4628480 bytes<\/span><\/div>\n
ORA-00205: error in identifying control file, check alert log for more info<\/span><\/div>\n
<\/span><\/div>\n
<\/span><\/div>\n
SQL> create spfile from pfile;<\/span><\/div>\n
<\/span><\/div>\n
File created.<\/span><\/div>\n
<\/span><\/div>\n
SQL> shutdown abort<\/span><\/div>\n
ORACLE instance shut down.<\/span><\/div>\n
      <\/span><\/div>\n
SQL> <\/span><\/div>\n
SQL> <\/span><\/div>\n
SQL> startup<\/span><\/div>\n
ORACLE instance started.<\/span><\/div>\n
<\/span><\/div>\n
Total System Global Area 1071333376 bytes<\/span><\/div>\n
Fixed Size <\/span> <\/span>    1349732 bytes<\/span><\/div>\n
Variable Size <\/span> <\/span>  281020316 bytes<\/span><\/div>\n
Database Buffers <\/span>  784334848 bytes<\/span><\/div>\n
Redo Buffers <\/span> <\/span>    4628480 bytes<\/span><\/div>\n
ORA-00205: error in identifying control file, check alert log for more info<\/span><\/div>\n
<\/span><\/div>\n
<\/span><\/div>\n
SQL> <\/span><\/div>\n<\/div>\n
<\/div>\n
 7) Colocar a sintaxe da criacao de banco em um arquivo buscar na documentacao e subsittuir somente o nome do banco e as senhas. Arquivo db.sql<\/div>\n
<\/div>\n
\n
CREATE<\/span> DATABASE PROD1<\/span><\/div>\n
     <\/span>USER<\/span> SYS <\/span>IDENTIFIED<\/span> <\/span>BY<\/span> oracle<\/span><\/div>\n
     <\/span>USER<\/span> SYSTEM <\/span>IDENTIFIED<\/span> <\/span>BY<\/span> oracle<\/span><\/div>\n
     EXTENT MANAGEMENT LOCAL<\/span><\/div>\n
     UNDO TABLESPACE undotbs<\/span><\/div>\n
     <\/span>DEFAULT<\/span> TEMPORARY TABLESPACE tempts1<\/span><\/div>\n
     <\/span>DEFAULT<\/span> TABLESPACE users;<\/span><\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
 8) Criar o banco de dados <\/div>\n
\n

<\/span><\/div>\n
-bash-3.2$ sqlplus \/ as sysdba @db.sql<\/span><\/div>\n
<\/span><\/div>\n
SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 6 21:53:30 2015<\/span><\/div>\n
<\/span><\/div>\n
Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span><\/div>\n
<\/span><\/div>\n
<\/span><\/div>\n
Connected to:<\/span><\/div>\n
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production<\/span><\/div>\n
With the Par
\ntitioning, OLAP, Data Mining and Real Application Testing options<\/span><\/div>\n
<\/span><\/div>\n
<\/span><\/div>\n
<\/div>\n
Database created.<\/span><\/div>\n

<\/span><\/div>\n

<\/span><\/div>\n<\/div>\n
 9) Instalar o dicionario de dados <\/div>\n
<\/div>\n
rdbms<\/div>\n
\n
SQL> @catalog.sql<\/div>\n<\/div>\n
\n
SQL> @catproc.sql<\/span><\/div>\n<\/div>\n
\n
SQL>  connect system\/oracle <\/div>\n
SQL> @?\/sqlplus\/admin\/pupbld.sql<\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
10) Instalar o enteprise manager database control<\/div>\n
\n

<\/span><\/div>\n
SQL> alter user dbsnmp account unlock identified by oracle;<\/span><\/div>\n
<\/span><\/div>\n

<\/p>\n

User altered.<\/span><\/div>\n

<\/span><\/div>\n<\/div>\n
<\/p>\n
-bash-3.2$ emca -config dbcontrol db -repos create<\/span><\/div>\n
<\/span><\/div>\n
STARTED EMCA em 06\/04\/2015 22:13:52<\/span><\/div>\n
Assistente de Configura\u00e7\u00e3o do EM, Produ\u00e7\u00e3o da Vers\u00e3o 11.2.0.3.0<\/span><\/div>\n
Copyright (c) 2003, 2011, Oracle. Todos os direitos reservados.<\/span><\/div>\n
<\/span><\/div>\n
Especifique as seguintes informa\u00e7\u00f5es:<\/span><\/div>\n
SID do Banco de Dados: PROD1<\/span><\/div>\n
N\u00famero da porta do listener: 1521<\/span><\/div>\n
ORACLE_HOME do Listener [ \/u01\/app\/oracle\/product\/11.2.0\/grid ]: <\/span><\/div>\n
Senha para o usu\u00e1rio SYS:  <\/span><\/div>\n
Senha do usu\u00e1rio DBSNMP:  <\/span><\/div>\n
Senha do usu\u00e1rio SYSMAN:  <\/span><\/div>\n
Endere\u00e7o de e-mail para notifica\u00e7\u00f5es (opcional): <\/span><\/div>\n
Servidor de Sa\u00edda de Correio (SMTP) para notifica\u00e7\u00f5es (opcional): <\/span><\/div>\n
—————————————————————–<\/span><\/div>\n
<\/span><\/div>\n
Voc\u00ea especificou as seguintes defini\u00e7\u00f5es<\/span><\/div>\n
<\/span><\/div>\n
ORACLE_HOME do banco de dados ……………. \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1<\/span><\/div>\n
<\/span><\/div>\n
Nome do host local ……………. srv01<\/span><\/div>\n
ORACLE_HOME do Listener ……………. \/u01\/app\/oracle\/product\/11.2.0\/grid<\/span><\/div>\n
N\u00famero da porta do listener ……………. 1521<\/span><\/div>\n
SID do Banco de Dados ……………. PROD1<\/span><\/div>\n
Endere\u00e7o de e-mail para notifica\u00e7\u00f5es …………… <\/span><\/div>\n
Servidor de Sa\u00edda de Correio (SMTP) para notifica\u00e7\u00f5es …………… <\/span><\/div>\n
<\/span><\/div>\n
—————————————————————–<\/span><\/div>\n
Deseja continuar? [sim(Y)\/n\u00e3o(N)]: Y<\/span><\/div>\n
06\/04\/2015 22:14:06 oracle.sysman.emcp.EMConfig perform<\/span><\/div>\n
INFO: Esta opera\u00e7\u00e3o est\u00e1 sendo registrada em \/u01\/app\/oracle\/cfgtoollogs\/emca\/PROD1\/emca_2015_04_06_22_13_52.log.<\/span><\/div>\n
06\/04\/2015 22:14:06 oracle.sysman.emcp.EMReposConfig createRepository<\/span><\/div>\n

<\/p>\n

INFO: Criando o reposit\u00f3rio do EM (isso pode demorar um pouco)…<\/span><\/p>\n
06\/04\/2015 22:16:29 oracle.sysman.emcp.EMReposConfig invoke<\/span><\/div>\n
INFO: Reposit\u00f3rio criado com sucesso<\/span><\/div>\n
06\/04\/2015 22:16:32 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository<\/span><\/div>\n
INFO: Fazendo upload dos dados de configura\u00e7\u00e3o para o reposit\u00f3rio EM (isso pode demorar um pouco) …<\/span><\/div>\n
06\/04\/2015 22:17:22 oracle.sysman.emcp.EMReposConfig invoke<\/span><\/div>\n
INFO: Dados de configura\u00e7\u00e3o submetidos a upload com sucesso<\/span><\/div>\n
06\/04\/2015 22:17:24 oracle.sysman.emcp.util.DBControlUtil secureDBConsole<\/span><\/div>\n
INFO: Protegendo o Database Control (isso pode demorar um pouco) …<\/span><\/div>\n
06\/04\/2015 22:18:06 oracle.sysman.emcp.util.DBControlUtil secureDBConsole<\/span><\/div>\n
INFO: Database Control protegido com sucesso.<\/span><\/div>\n
06\/04\/2015 22:18:06 oracle.sysman.emcp.util.DBControlUtil startOMS<\/span><\/div>\n
INFO: Iniciando Database Control (isso pode demorar um pouco)…<\/span><\/div>\n
06\/04\/2015 22:18:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration<\/span><\/div>\n
INFO: Database Control iniciado com sucesso<\/span><\/div>\n
06\/04\/2015 22:18:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration<\/span><\/div>\n
INFO: >>>>>>>>>>> O URL do Database Control \u00e9 https:\/\/srv01:1158\/em <<<<<<<<<<<<\/span><\/div>\n
06\/04\/2015 22:18:33 oracle.sysman.emcp.EMDBPostConfig invoke<\/span><\/div>\n
WARNING: <\/span><\/div>\n
************************  WARNING  ************************<\/span><\/div>\n
<\/span><\/div>\n
O Reposit\u00f3rio de Gerenciamento est\u00e1 no modo seguro, no qual os dados do Enterprise Manager ser\u00e3o criptografados. A chave de criptografia se encontra no arquivo: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/srv01_PROD1\/sysman\/config\/emkey.ora. Certifique-se de que esse arquivo tem backup, pois os dados criptografados n\u00e3o poder\u00e3o mais ser utilizados se o arquivo se perder. <\/span><\/div>\n
<\/span><\/div>\n
***********************************************************<\/span><\/div>\n
A configura\u00e7\u00e3o do Enterprise Manager foi conclu\u00edda com sucesso<\/span><\/div>\n

<\/span><\/p>\n

FINISHED EMCA em 06\/04\/2015 22:18:33<\/span><\/div>\n

<\/span><\/div>\n

<\/span><\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Iremos criar um banco de dados Oracle a partir da linha de comando, sem uso de ferramentas. Para isso, faremos a divis\u00e3o das etapas em passos mostrados abaixo: 1) Alterar o \/etc\/oratab adicionando seu novo banco -bash-3.2$  -bash-3.2$ cat \/etc\/oratab … Continue lendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56,70,146,180,189],"tags":[],"class_list":["post-72","post","type-post","status-publish","format-standard","hentry","category-create-database-oracle","category-dbca","category-linha-de-comando-dbca","category-ocm","category-oracle"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=72"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/72\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=72"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=72"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}