Neste documento estarei mostrando como criar um banco de dados via dbca, na linha de comando.
O interessante e que o comando abaixo demora em torno de 10 minutos com o enteprise manager database control ja criado.<\/p>\n
Primeiro, va ate o arquivo \/etc\/oratab e incluia a linha com um nome de um banco, pode ser algum somente de teste ou o que vai ser criado. Rodaremos o . oraenv para configurar as variaveis de ambiente.<\/p>\n
<\/p><\/blockquote>\n
-bash-3.2$ cat \/etc\/oratab<\/p>\n<\/code><\/p>\n
# This file is used by ORACLE utilities. It is created by root.sh<\/span><\/code><\/div>\n
<\/code><\/p>\n# and updated by either Database Configuration Assistant while creating<\/span><\/code><\/div>\n
<\/code><\/p>\n# a database or ASM Configuration Assistant while creating ASM instance.<\/span><\/code><\/div>\n
<\/p>\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<\/p>\n
*:\/u01\/app\/oracle\/agent11g:N<\/span><\/div>\n
<\/span>
<\/span><\/div>\ndbca -silent > criadb.sh<\/p>\n
Conteudo do Arquivo criadb.sh<\/p>\n
dbca <\/span>-silent<\/span> <\/span><\/span><\/div>\n<\/span>-createDatabase<\/span> <\/span><\/span><\/div>\n<\/span>-templateName<\/span> General_Purpose.dbc <\/span><\/span><\/div>\n<\/span>-gdbName<\/span> PROD1 <\/span><\/span><\/div>\n<\/span>-sysPassword<\/span> oracle <\/span><\/span><\/div>\n<\/span>-systemPassword<\/span> oracle <\/span><\/span><\/div>\n<\/span>-emConfiguration<\/span> LOCAL <\/span><\/span><\/div>\n<\/span>-dbsnmpPassword<\/span> oracle <\/span><\/span><\/div>\n<\/span>-sysmanPassword<\/span> oracle <\/span><\/span><\/div>\n<\/span>-datafileDestination<\/span> <\/span>'<\/span>\/u01\/app\/oracle\/oradata<\/span>'<\/span> <\/span><\/span><\/div>\n<\/span>-recoveryAreaDestination<\/span> <\/span>'<\/span>\/u01\/app\/oracle\/fast<\/span>'<\/span> <\/span><\/span><\/div>\n<\/span>-storageType<\/span> FS <\/span><\/span><\/div>\n<\/span>-characterSet<\/span> AL32UTF8 <\/span><\/span><\/div>\n<\/span>-sampleSchema<\/span> true<\/span>
<\/span>Removendo algumas linhas e fazendo ajustes o arquivo ficara pronto.<\/span>
<\/span>Dai o proximo passo executa-lo:<\/span>
<\/span>sh criadb.sh<\/span>
<\/span><\/p>\n-bash-3.2$ sh criadb.sh <\/span><\/div>\nFalha ao limpar as etapas<\/span><\/div>\n5% conclu\u00eddo<\/span><\/div>\nCopiando arquivos de banco de dados<\/span><\/div>\n7% conclu\u00eddo<\/span><\/div>\n8% conclu\u00eddo<\/span><\/div>\n38% conclu\u00eddo<\/span><\/div>\nCriando e iniciando a inst\u00e2ncia Oracle<\/span><\/div>\n39% conclu\u00eddo<\/span><\/div>\n41% conclu\u00eddo<\/span><\/div>\n45% conclu\u00eddo<\/span><\/div>\n46% conclu\u00eddo<\/span><\/div>\n50% conclu\u00eddo<\/span><\/div>\n54% conclu\u00eddo<\/span><\/div>\n55% conclu\u00eddo<\/span><\/div>\n56% conclu\u00eddo<\/span><\/div>\n59% conclu\u00eddo<\/span><\/div>\n61% conclu\u00eddo<\/span><\/div>\nRegistrando o banco de dados no Oracle Restart<\/span><\/div>\n66% conclu\u00eddo<\/span><\/div>\nConcluindo Cria\u00e7\u00e3o de Banco de Dados<\/span><\/div>\n70% conclu\u00eddo<\/span><\/div>\n73% conclu\u00eddo<\/span><\/div>\n76% conclu\u00eddo<\/span><\/div>\n86% conclu\u00eddo<\/span><\/div>\n96% conclu\u00eddo<\/span><\/div>\n100% conclu\u00eddo<\/span><\/div>\n<\/span><\/p>\n
Verifique o arquivo de log \"\/u01\/app\/oracle\/cfgtoollogs\/dbca\/PROD1\/PROD10.log\" para obter mais detalhes.<\/span><\/div>\n
<\/span><\/p>\n-bash-3.2$ . oraenv<\/span><\/div>\nORACLE_SID = [PROD1] ? PROD1<\/span><\/div>\nThe Oracle base remains unchanged with value \/u01\/app\/oracle<\/span><\/div>\n-bash-3.2$ emctl status dbconsole<\/span><\/div>\nOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 <\/span><\/div>\nCopyright (c) 1996, 2011 Oracle Corporation. All rights reserved.<\/span><\/div>\nhttps:\/\/srv01:1158\/em\/console\/aboutApplication<\/span><\/div>\n<\/span><\/p>\n
Oracle Enterprise Manager 11g is not running.<\/span><\/div>\n
<\/span><\/div>\n
<\/span><\/div>\n<\/div>\nDessa forma seu banco ja esta criado com o modelo e exemplos de esquema, de forma com que voce nao gastou 10 minutos para completar a operacao.<\/span><\/div>\n<\/div>\n<\/div>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
Neste documento estarei mostrando como criar um banco de dados via dbca, na linha de comando.O interessante e que o comando abaixo demora em torno de 10 minutos com o enteprise manager database control ja criado. Primeiro, va ate o … Continue lendo