Criando os diret\u00f3rios que abrigar\u00e3o os dados, archives e FRA do Oracle:<\/p>\n\n\n
\n[oracle@oel8 admin]$ mkdir -p \/oracle\/dados\n[oracle@oel8 admin]$ mkdir -p \/oracle\/fra\n[oracle@oel8 admin]$ mkdir -p \/oracle\/archives\n<\/pre><\/div>\n\n\nPermiss\u00f5es:<\/p>\n\n\n
\n[oracle@oel8 admin]$ chown -R oracle:oinstall \/oracle\/dados\/ \/oracle\/fra\/ \/oracle\/archives\/\n[oracle@oel8 admin]$ chmod 775 \/oracle\/dados\/ \/oracle\/fra\/ \/oracle\/archives\/\n<\/pre><\/div>\n\n\nPar\u00e2metros usados:<\/p>\n\n\n
\ndbca -silent -createDatabase \\\n -responseFile NO_VALUE \\\n -gdbName RMANDB \\\n -templateName General_Purpose.dbc \\\n -sid ${ORACLE_SID} \\\n -createAsContainerDatabase false \\\n -sysPassword Oracle123 \\\n -systemPassword Oracle123 \\\n -emConfiguration NONE \\\n -dvConfiguration false \\\n -olsConfiguration false \\\n -datafileDestination \/oracle\/dados \\\n -redoLogFileSize 50 \\\n -recoveryAreaDestination \/oracle\/fra \\\n -recoveryAreaSize 500 \\\n -storageType FS \\\n -runCVUChecks false \\\n -enableArchive true \\\n -archiveLogMode AUTO \\\n -archiveLogDest \/oracle\/archives \\\n -automaticMemoryManagement false \\\n -createListener LISTENER \\\n -useOMF true \\\n -databaseConfigType SINGLE \\\n -characterSet AL32UTF8 \\\n -sampleSchema false \\\n -totalMemory 2048 \\\n -databaseType MULTIPURPOSE \n<\/pre><\/div>\n\n\nDevido ao pouco espa\u00e7o de mem\u00f3ria na m\u00e1quina, o Oracle reporta um erro por conta disso (al\u00e9m do warning sobre o espa\u00e7o m\u00ednimo de FRA):<\/p>\n\n\n
\n[oracle@oel8 admin]$ dbca -silent -createDatabase \\\n> -responseFile NO_VALUE \\\n> -gdbName RMANDB \\\n> -templateName General_Purpose.dbc \\\n> -sid ${ORACLE_SID} \\\n> -createAsContainerDatabase false \\\n> -sysPassword Oracle123 \\\n> -systemPassword Oracle123 \\\n> -emConfiguration NONE \\\n> -dvConfiguration false \\\n> -olsConfiguration false \\\n> -datafileDestination \/oracle\/dados \\\n> -redoLogFileSize 50 \\\n> -recoveryAreaDestination \/oracle\/fra \\\n> -recoveryAreaSize 500 \\\n> -storageType FS \\\n> -runCVUChecks false \\\n> -enableArchive true \\\n> -archiveLogMode AUTO \\\n> -archiveLogDest \/oracle\/archives \\\n> -automaticMemoryManagement false \\\n> -createListener LISTENER \\\n> -useOMF true \\\n> -databaseConfigType SINGLE \\\n> -characterSet AL32UTF8 \\\n> -sampleSchema false \\\n> -totalMemory 2048 \\\n> -databaseType MULTIPURPOSE\n[WARNING] [DBT-06801] Specified Fast Recovery Area size (500 MB) is less than the recommended value.\n CAUSE: Fast Recovery Area size should at least be three times the database size (692 MB).\n ACTION: Specify Fast Recovery Area Size to be at least three times the database size.\n[WARNING] [DBT-11209] Current available memory is less than the required available memory (2,048MB) for creating the database.\n CAUSE: Following nodes do not have required available memory :\n Node:oel8 Available memory:1.8942GB (1986164.0KB)\n \n[FATAL] [DBT-11214] Automatic Memory Management is not a feasible option on the system.\n CAUSE: There is not enough free space on volume \/dev\/shm to allocate 2,048MB.\n[oracle@oel8 admin]$\n<\/pre><\/div>\n\n\nAumentando a mem\u00f3ria da m\u00e1quina virtual:<\/p>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-473.png\")
<\/figure>\n\n\n\nDepois alterado comando para:<\/p>\n\n\n
\ndbca -silent -createDatabase \\\n -responseFile NO_VALUE \\\n -gdbName RMANDB \\\n -templateName General_Purpose.dbc \\\n -sid ${ORACLE_SID} \\\n -createAsContainerDatabase false \\\n -sysPassword Oracle123 \\\n -systemPassword Oracle123 \\\n -emConfiguration NONE \\\n -dvConfiguration false \\\n -olsConfiguration false \\\n -datafileDestination \/oracle\/dados \\\n -redoLogFileSize 50 \\\n -recoveryAreaDestination \/oracle\/fra \\\n -recoveryAreaSize 700 \\\n -storageType FS \\\n -runCVUChecks false \\\n -enableArchive true \\\n -archiveLogMode AUTO \\\n -archiveLogDest \/oracle\/archives \\\n -automaticMemoryManagement false \\\n -createListener LISTENER \\\n -useOMF true \\\n -databaseConfigType SINGLE \\\n -characterSet AL32UTF8 \\\n -sampleSchema false \\\n -totalMemory 2048 \\\n -databaseType MULTIPURPOSE\n<\/pre><\/div>\n\n\nBanco criado com sucesso:<\/p>\n\n\n
\n[oracle@oel8 ~]$ dbca -silent -createDatabase \\\n> -responseFile NO_VALUE \\\n> -gdbName RMANDB \\\n> -templateName General_Purpose.dbc \\\n> -sid ${ORACLE_SID} \\\n> -createAsContainerDatabase false \\\n> -sysPassword Oracle123 \\\n> -systemPassword Oracle123 \\\n> -emConfiguration NONE \\\n> -dvConfiguration false \\\n> -olsConfiguration false \\\n> -datafileDestination \/oracle\/dados \\\n> -redoLogFileSize 50 \\\n> -recoveryAreaDestination \/oracle\/fra \\\n> -recoveryAreaSize 700 \\\n> -storageType FS \\\n> -runCVUChecks false \\\n> -enableArchive true \\\n> -archiveLogMode AUTO \\\n> -archiveLogDest \/oracle\/archives \\\n> -automaticMemoryManagement false \\\n> -createListener LISTENER \\\n> -useOMF true \\\n> -databaseConfigType SINGLE \\\n> -characterSet AL32UTF8 \\\n> -sampleSchema false \\\n> -totalMemory 2048 \\\n> -databaseType MULTIPURPOSE\n[WARNING] [DBT-06801] Specified Fast Recovery Area size (700 MB) is less than the recommended value.\n CAUSE: Fast Recovery Area size should at least be three times the database size (692 MB).\n ACTION: Specify Fast Recovery Area Size to be at least three times the database size.\n[WARNING] [DBT-06801] Specified Fast Recovery Area size (700 MB) is less than the recommended value.\n CAUSE: Fast Recovery Area size should at least be three times the database size (2,252 MB).\n ACTION: Specify Fast Recovery Area Size to be at least three times the database size.\nPrepare for db operation\n10% complete\nCopying database files\n40% complete\nCreating and starting Oracle instance\n42% complete\n46% complete\n50% complete\n54% complete\n60% complete\nCompleting Database Creation\n66% complete\n69% complete\n70% complete\nExecuting Post Configuration Actions\n100% complete\nDatabase creation complete. For details check the logfiles at:\n \/oracle\/18.0.0\/base\/cfgtoollogs\/dbca\/RMANDB.\nDatabase Information:\nGlobal Database Name:RMANDB\nSystem Identifier(SID):RMANDB\nLook at the log file "\/oracle\/18.0.0\/base\/cfgtoollogs\/dbca\/RMANDB\/RMANDB.log" for further details.\n[oracle@oel8 ~]$\n<\/pre><\/div>\n\n\nConsultando banco:<\/p>\n\n\n
\n[oracle@oel8 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Sun Apr 5 21:59:01 2020\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n \nSQL> select instance_name,status from gv$instance;\n \nINSTANCE_NAME STATUS\n---------------- ------------\nRMANDB OPEN\n \nSQL> select banner from v$version;\n \nBANNER\n--------------------------------------------------------------------------------\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\n \nSQL>\n<\/pre><\/div>\n\n\nConsultando oratab:<\/p>\n\n\n
\n[oracle@oel8 ~]$ cat \/etc\/oratab\n#\n \n \n \n# This file is used by ORACLE utilities. It is created by root.sh\n# and updated by either Database Configuration Assistant while creating\n# a database or ASM Configuration Assistant while creating ASM instance.\n \n# A colon, ':', is used as the field terminator. A new line terminates\n# the entry. Lines beginning with a pound sign, '#', are comments.\n#\n# Entries are of the form:\n# $ORACLE_SID:$ORACLE_HOME:<N|Y>:\n#\n# The first and second fields are the system identifier and home\n# directory of the database respectively. The third field indicates\n# to the dbstart utility that the database should , "Y", or should not,\n# "N", be brought up at system boot time.\n#\n# Multiple entries with the same $ORACLE_SID are not allowed.\n#\n#\nRMANDB:\/oracle\/18.0.0\/product:N\n[oracle@oel8 ~]$\n<\/pre><\/div>\n\n\nEditando o mesmo para que possa ser reinicializado quando a m\u00e1quina virtual subir:<\/p>\n\n\n
\n[oracle@oel8 ~]$ vi \/etc\/oratab\n<\/pre><\/div>\n\n\nConte\u00fado:<\/p>\n\n\n
\n#\n \n \n \n# This file is used by ORACLE utilities. It is created by root.sh\n# and updated by either Database Configuration Assistant while creating\n# a database or ASM Configuration Assistant while creating ASM instance.\n \n# A colon, ':', is used as the field terminator. A new line terminates\n# the entry. Lines beginning with a pound sign, '#', are comments.\n#\n# Entries are of the form:\n# $ORACLE_SID:$ORACLE_HOME:<N|Y>:\n#\n# The first and second fields are the system identifier and home\n# directory of the database respectively. The third field indicates\n# to the dbstart utility that the database should , "Y", or should not,\n# "N", be brought up at system boot time.\n#\n# Multiple entries with the same $ORACLE_SID are not allowed.\n#\n#\nRMANDB:\/oracle\/18.0.0\/product:Y\n<\/pre><\/div>\n\nAl\u00e9m do artigo do Tim que usei como base, li com cuidado todos os par\u00e2metros da documenta\u00e7\u00e3o Oracle, para entender todos os valores poss\u00edveis e suas defini\u00e7\u00f5es. A tabela voc\u00ea encontra neste LINK<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"Para quem teve a oportunidade de aprender a tocar algum instrumento musical, j\u00e1 se deparou com o termo: tocar uma m\u00fasica “cover”. Esse \u00e9 o processo onde voc\u00ea interpreta uma m\u00fasica que j\u00e1 existe, no intuito de se divertir, e principalmente: aprender. Aqui na TI, especificamente na \u00e1rea de banco de dados, n\u00e3o seria diferente. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[19],"class_list":["post-1242","post","type-post","status-publish","format-standard","hentry","category-administration","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1242"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1242\/revisions"}],"predecessor-version":[{"id":9294,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1242\/revisions\/9294"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}