Foi mal pessoal, pensei que a minha msg não tivesse sido enviada, ai duplicou
--- Em oracle_br@yahoogrupos.com.br, "netodba" <neto.longhi@...> escreveu > > Eu já tive que montar fisicamente e configurar um ODA em um cliente, é > realmente muito fácil =) > > A única coisa que eu não gostei foi o tamanho do storage, 4TB é pouco, tem > que comprar storage adicional e tal. > > > --- 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 > > >
