É bem legal, né ? Essa é a vantagem de um sistema fechado/engenheirado : é claro que nada nem ninguém impede de termos coisas semelhantes num sistema aberto/montado/customizado (e certamente todos nós já temos nossos scripts / tools / mnodelos para aplicação de patches, para criação de databases, para healthcheck, para performance, etc), mas num sistema fechado/engenheirado muitas dessas coisas já vêm prontas, ou então o fornecedor as disponibiliza para download.... Uma vez um amigo meu me disse que o adicional que vc paga a mais optando por um sistema engenheirado compradao com a montagem de um sistema idêntico customizado é em parte o valor do investimento que o fornecedor fez a mais no setup/ambientalização, e que por já vir pronto é o que vc não desembolsa na administração/configuração, principalmente com ganho de tempo mas também não tendo que trazer expertise se ela não existir in-house: nem sempre essa "conta" bate/fecha certinho, sempre tem margens de lucro e quetais, mas é algo que não tá fora da realidade, não, essa afirmação...
[]s Chiappa --- Em oracle_br@yahoogrupos.com.br, <vitorjr81@...> escreveu > > A titulo de curiosidade, pra quem nunca viu, compartilho a âdificuldadeâ > em se criar um database no ODA: :) > > > > [root@hostname1 ~]# oakcli create database -db basedb -oh OraDb11203_home1 > -params basedbdb > > > Please enter the 'root' user password: > Please re-enter the 'root' user password: > > > Please enter the 'oracle' user password: > Please re-enter the 'oracle' user password: > > > Please enter the 'SYSASM' user password: (During deployment we set the SYSASM > password to '<senha>'): > Please re-enter the 'SYSASM' user password: > Please select one of the following for Database Deployment [1 .. 3]: > 1 => EE : Enterprise Edition > 2 => RACONE > 3 => RAC > 3 > Selected value is: RAC > Please select one of the following for Database Class [1 .. 6]: > 1 => Very Small > 2 => Small > 3 => Medium > 4 => Large > 5 => Extra Large > 6 => Extra Extra Large > 4 > Selected value is: Large > > > Do you want to set up the EM Dbconsole for this database: [ Y | N ]?Y > > > Please enter the 'ASMSNMP' user password: (During deployment we set the > ASMSNMP password to '<senha>'): > Please re-enter the 'ASMSNMP' user password: > INFO : Logging all actions in > /opt/oracle/oak/onecmd/tmp/hostname1-20131016171325.log and traces in > /opt/oracle/oak/onecmd/tmp/hostname1-20131016171325.trc > INFO : Loading configuration file > /opt/oracle/oak/onecmd/create_database.params... > INFO : Creating nodelist files... > INFO : Setting up ssh for root... > INFO : Setting up ssh across the private network... > ............done > INFO : Running as root: /usr/bin/ssh -l root 192.168.16.24 > /root/DoAllcmds.sh > INFO : Running as root: /usr/bin/ssh -l root 192.168.16.25 > /root/DoAllcmds.sh > INFO : Background process 21830 (node: 192.168.16.24) gets done with the > exit code 0 > INFO : Background process 21866 (node: 192.168.16.25) gets done with the > exit code 0 > INFO : Done setting up ssh > INFO : Running /usr/bin/rsync -tarvz /opt/oracle/oak/onecmd/ > root@...:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log > --exclude=*trc --exclude=*rpm to sync directory</opt/oracle/oak/onecmd> on > node <192.168.16.25> > SUCCESS: Ran /usr/bin/rsync -tarvz /opt/oracle/oak/onecmd/ > root@...:/opt/oracle/oak/onecmd --exclude=*zip --exclude=*gz --exclude=*log > --exclude=*trc --exclude=*rpm and it returned: RC=0 > sending incremental file list > ./ > create_database.params > tmp/ > tmp/DoAllcmds.sh > tmp/all_nodes > tmp/db_nodes > tmp/priv_ip_group > tmp/vip_node > > > sent 5911 bytes received 183 bytes 4062.67 bytes/sec > total size is 11868680 speedup is 1947.60 > > > ..........done > INFO : did not do scp for node: hostname1 > INFO : Running as root: /usr/bin/ssh -l root hostname1 /root/DoAllcmds.sh > INFO : Running as root: /usr/bin/ssh -l root enterprise2 /root/DoAllcmds.sh > INFO : Background process 23128 (node: hostname1) gets done with the exit > code 0 > INFO : Background process 23164 (node: enterprise2) gets done with the exit > code 0 > INFO : did not do scp for node: hostname1 > INFO : Running as root: /usr/bin/ssh -l root hostname1 > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171408.sh > INFO : Running as root: /usr/bin/ssh -l root enterprise2 > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171408.sh > INFO : Background process 23224 (node: hostname1) gets done with the exit > code 0 > INFO : Background process 23260 (node: enterprise2) gets done with the exit > code 0 > INFO : setting up ssh for user oracle... > ..........done > INFO : checking nodes in /opt/oracle/oak/onecmd/tmp/db_nodes... > ... > SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and > alive. > INFO : checking SSH setup for user (oracle) on nodes in > /opt/oracle/oak/onecmd/tmp/db_nodes... > INFO : did not do scp for node: hostname1 > INFO : This is root, will become oracle and run: /bin/su oracle -c > /usr/bin/ssh -l oracle hostname1 > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171428.sh > INFO : Running on the local node: /bin/su oracle -c > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171428.sh > INFO : Background process 24577 (node: hostname1) gets done with the exit > code 0 > INFO : This is root, will become oracle and run: /bin/su oracle -c > /usr/bin/ssh -l oracle enterprise2 > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171428.sh > INFO : Background process 24613 (node: enterprise2) gets done with the exit > code 0 > INFO : Creating database using dbca... > INFO : did not do scp for node: hostname1 > INFO : Running as root: /usr/bin/ssh -l root hostname1 > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171429.sh > INFO : Running as root: /usr/bin/ssh -l root enterprise2 > /opt/oracle/oak/onecmd/tmp/DoAllcmds-20131016171429.sh > INFO : Background process 24692 (node: hostname1) gets done with the exit > code 0 > INFO : Background process 24728 (node: enterprise2) gets done with the exit > code 0 > INFO : Running dbca using /opt/oracle/oak/onecmd/tmp/dbca-basedb.sh on > hostname1 as oracle... > INFO : Check output in > /opt/oracle/oak/onecmd/tmp/dbca-basedb-20131016171325.log > INFO : This is root, will become oracle and run: /bin/su oracle -c > /usr/bin/ssh -l oracle hostname1 /opt/oracle/oak/onecmd/tmp/dbca-basedb.sh > INFO : Running on the local node: /bin/su oracle -c > /opt/oracle/oak/onecmd/tmp/dbca-basedb.sh > Instance basedb1 is running on node hostname1 > Instance basedb2 is running on node enterprise2 > INFO : One or more instances running on the cluster nodes. > INFO : Running export > ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1;/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl > setenv database -d basedb -t 'TZ=America/Sao_Paulo' to set DB timezone > INFO : Running export > ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1;/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl > stop database -d basedb to stop DB > INFO : Running export > ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1;/u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl > start database -d basedb to start DB > INFO : Node name is : hostname1 > INFO : Running the command /u01/app/11.2.0.3/grid/bin/crsctl stat resource > ora.basedb.db -p > INFO : Node name is : hostname1 > INFO : Running the command /u01/app/11.2.0.3/grid/bin/crsctl stat resource > ora.basedb.db -p > .INFO : did not do scp for node: hostname1 > .. > INFO : This is root, will become oracle and run: /bin/su oracle -c > /usr/bin/ssh -l oracle hostname1 > /opt/oracle/oak/onecmd/tmp/dbupdates-basedb.sh > INFO : Running on the local node: /bin/su oracle -c > /opt/oracle/oak/onecmd/tmp/dbupdates-basedb.sh > INFO : Running /u01/app/11.2.0.3/grid/bin/crsctl stop resource > ora.basedb.db -f > CRS-2673: Attempting to stop 'ora.basedb.db' on 'hostname1' > CRS-2673: Attempting to stop 'ora.basedb.db' on 'enterprise2' > CRS-2677: Stop of 'ora.basedb.db' on 'hostname1' succeeded > CRS-2677: Stop of 'ora.basedb.db' on 'enterprise2' succeeded > INFO : Running /u01/app/11.2.0.3/grid/bin/crsctl start resource > ora.basedb.db > CRS-2672: Attempting to start 'ora.basedb.db' on 'enterprise2' > CRS-2672: Attempting to start 'ora.basedb.db' on 'hostname1' > CRS-2676: Start of 'ora.basedb.db' on 'hostname1' succeeded > CRS-2676: Start of 'ora.basedb.db' on 'enterprise2' succeeded > INFO : Setting up EM Db control... > INFO : This is root, will become oracle and run: /bin/su oracle -c > /usr/bin/ssh -l oracle hostname1 /opt/oracle/oak/onecmd/tmp/runemca.sh > INFO : Running on the local node: /bin/su oracle -c > /opt/oracle/oak/onecmd/tmp/runemca.sh > INFO : Setting up DBconsole 2nd node > /opt/oracle/oak/onecmd/tmp/setupdbconsolenodeexpect.sh > INFO : This is root, will become oracle and run: /bin/su oracle -c > /usr/bin/ssh -l oracle hostname1 > /opt/oracle/oak/onecmd/tmp/setupdbconsolenodeexpect.sh > INFO : Running on the local node: /bin/su oracle -c > /opt/oracle/oak/onecmd/tmp/setupdbconsolenodeexpect.sh > INFO : Setting up EM Timezone /opt/oracle/oak/onecmd/tmp/setuptzem.sh > .INFO : did not do scp for node: hostname1 > .. > INFO : Running as root: /usr/bin/ssh -l root hostname1 > /opt/oracle/oak/onecmd/tmp/setuptzem.sh > ... > INFO : Running as root: /usr/bin/ssh -l root enterprise2 > /opt/oracle/oak/onecmd/tmp/setuptzem.sh > INFO : Setting up DBcontrol autostartup > /opt/oracle/oak/onecmd/tmp/setupdbconsolestart.sh > .INFO : did not do scp for node: hostname1 > .. > INFO : Running as root: /usr/bin/ssh -l root hostname1 > /opt/oracle/oak/onecmd/tmp/setupdbconsolestart.sh > ... > INFO : Running as root: /usr/bin/ssh -l root enterprise2 > /opt/oracle/oak/onecmd/tmp/setupdbconsolestart.sh > SUCCESS: 2013-10-16 17:58:27: Successfully created the database basedb > INFO : Resecuring environment... > INFO : Remvoing the SSH setup for root... > > > INFO : Running as root: /usr/bin/ssh -l root hostname1 chmod 751 > /opt/oracle/oak/onecmd/tmp > > > INFO : Running as root: /usr/bin/ssh -l root enterprise2 chmod 751 > /opt/oracle/oak/onecmd/tmp > INFO : Running as root: /usr/bin/ssh -l root enterprise2 /bin/rm -rf > /root/.ssh > INFO : Running as root: /usr/bin/ssh -l root hostname1 /bin/rm -rf > /root/.ssh > > > > > > > > > > > > > Enviado do Email do Windows > > Att,/Regards, > > > Vitor Jr. > Infraestrutura / Infrastructure Team > Oracle 11g DBA Certified Professional - OCP > Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid > Infrastructure Administrator - OCE > Oracle Database 11g Performance Tuning Certified Expert - OCE > Oracle Exadata 11g Certified Implementation Specialist > Oracle Certified Associate, MySQL 5 > mail, gtalk e msn: vitorjr81@... > http://certificacaobd.com.br/ > skype: vjunior1981 > https://mybizcard.co/vitor.jr.385628 >