Hi. I wanted to know that to install Enterprise manager agent on windows. Do we have to do these things first then install Agent or directly we can do that? Please answer me
@sunilchunduri7 күн бұрын
👍 Thank you
@gotchihaeyo18257 күн бұрын
Shut Abort Startup Mount Rman) restore Datafile 5 ; Rman) recover Datafile 5 ; SQL) Alter database open ; Would this work as well with the Datafile 5 online? Thank you !!
@DB2_Oracle7 күн бұрын
This will work. As you have put the database in MOUNT mode However if you want to restore datafile while database is online, you need to mark that datafile offline Use alter tablespace command before restore
@beboalhag8 күн бұрын
sir from where can i download grid in video (unzip -qq oracle_DB_19cR300_Grid_LIN64_Home.ZIP -d /dbi/oracle/V19Grid) can you give me the link thank you
@DB2_Oracle8 күн бұрын
From the Oracle Website www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html
@sajimenon48889 күн бұрын
Very informative video. Keep up the great work!
@shaikshameer978312 күн бұрын
Thank you
@up167912 күн бұрын
But brother clustering is for load balancing also thn how it is in active passive
@DB2_Oracle12 күн бұрын
Oracle RAC can be configured as ACTIVE-ACTIVE or ACTIVE-PASSIVE based on your choice.
@Xocrona13 күн бұрын
Excellent and easy explanation! Really good video guide.
@nihadawad734013 күн бұрын
Many thanks from Palestine
@meryberry220814 күн бұрын
On the second node, I tried to add th eip address to the target and when I clicked on quick connect, it does not work writing that no targets are available. Although it worked in the first node. Why is this?
@randomstuff107616 күн бұрын
please use black theme
@BDBrightDBA18 күн бұрын
Could you pls share the pdf doc?
@CaPaCuLLe19 күн бұрын
Great content. What will happen if some reason the comunication between the nodes get lost and both nodes are PRIMARY, then after some time the connection got restored. In this case what will happen to the instances ? Is there a way to prioritize them so that one will remain as PRIMARY and the other one stops or fails ?
@benoitd9419 күн бұрын
very good , it should be great to have a tutorial on the management of space disk (datafiles, filesystem etc) for databases
@DB2_Oracle19 күн бұрын
Coming Up. This is long due.
@chakshujain724619 күн бұрын
Very informative. Thank you
@MuhammadTioLaksono20 күн бұрын
How i can download ibm cdc, where link. Without login to ibm
@DB2_Oracle20 күн бұрын
This does not use CDC. This uses only DB2
@suzannesellers738320 күн бұрын
Great explanation of something I never knew before.
@suzannesellers738320 күн бұрын
Excellent
@Koushikdutta11621 күн бұрын
installation got stuck in 62 % Logs INFO: oracle.sysman.top.oms:Renaming the file usermessaging.xml to usermessaging.xml INFO: oracle.sysman.top.oms:File is moved successful! INFO: oracle.sysman.top.oms:MDS Schema Creation status: COMPLETED INFO: oracle.sysman.top.oms:MDS Schema Creation is successful INFO: oracle.sysman.top.oms:_______________________________________________________________________ INFO: oracle.sysman.top.oms:Starting opss Schema Creation. INFO: oracle.sysman.top.oms:Debug: SCRIPT_HOME: null Can you help me out
@Koushikdutta11621 күн бұрын
Previously it got stuck in 54% during repo creation steps , issue got solve by running the below SQL> EXEC DBMS_STATS.unlock_schema_stats('SYSMAN'); SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SYSMAN');
@edgardonb22 күн бұрын
👏👏👏👏 congratulations. Now you have to do one to REactivate the standby when it stops in the different cases.
@suzannesellers738327 күн бұрын
Fantastic
@suzannesellers738327 күн бұрын
Hi, I have an interview tomorrow. I can always depend on you for the information I need.
@DB2_Oracle27 күн бұрын
Best of luck for your interview
@atiftemuri187728 күн бұрын
Hello Sir I need urgent assistance basically I downloaded both the 64 and 32 bit both are not working like when I click on setup and I confirm with yes a black screen shows for nano seconds and then vanishes what should I need to do sir
@DB2_Oracle28 күн бұрын
Which Operating system?
@atiftemuri187727 күн бұрын
@@DB2_Oracle Sir on windows 7 ultra
@atiftemuri187727 күн бұрын
@@DB2_Oracle Window 7 Sir
@MuhammadTioLaksonoАй бұрын
Why i restore incompatibility operating system
@DB2_OracleАй бұрын
Don't understand the question?
@MuhammadTioLaksono26 күн бұрын
@@DB2_Oracle do you any solution about backup from windows to linux database db2 ?
@SulisakVANNASINGАй бұрын
I need to award you 100000 stars
@DB2_OracleАй бұрын
This means a lot. Thank You.
@SulisakVANNASINGАй бұрын
very nice explanation
@sekharv4Ай бұрын
00:03 DB2 HADR Rolling Upgrade 02:51 Promotion of subscribing to the channel 06:02 Subscribe to The Amazing 09:05 Subscription and activation process explained 11:10 Upgrading DB2 HADR 13:33 Update to-do list and subscribe to the main feed 15:34 Updating DB2 HADR to 11.54 meters distance 17:16 HADR Rolling Upgrade Crafted by Merlin AI.00:03 DB2 HADR Rolling Upgrade 02:51 Promotion of subscribing to the channel 06:02 Subscribe to The Amazing 09:05 Subscription and activation process explained 11:10 Upgrading DB2 HADR 13:33 Update to-do list and subscribe to the main feed 15:34 Updating DB2 HADR to 11.54 meters distance 17:16 HADR Rolling Upgrade Crafted by Merlin AI.00:03 DB2 HADR Rolling Upgrade 02:51 Promotion of subscribing to the channel 06:02 Subscribe to The Amazing 09:05 Subscription and activation process explained 11:10 Upgrading DB2 HADR 13:33 Update to-do list and subscribe to the main feed 15:34 Updating DB2 HADR to 11.54 meters distance 17:16 HADR Rolling Upgrade
@xoxo0304Ай бұрын
Excellent tutorial. Very helpful to me, thank you very much.
@rokrollАй бұрын
Well done. Thanks
@kamruzzamanpintu8670Ай бұрын
Can you share the script.... Thanks
@shaikmahammadnabhi1664Ай бұрын
If possible can you please upload the Doc which you are shoing in the Video ! Thank you for sharing valuble information.
@matheusvicentim4101Ай бұрын
Hello, I'm trying to carry out the process, but I'm stuck with an error (listed below). The certificates (I got them through the browser, these are the url I'm calling) are in Wallet and the one from the company I work for is also in Wallet. The ACL has also been configured. The digital certificates obtained by the browser have the .crt extension. ORA-29273: HTTP request failed ORA-29024: Certificate validation failure ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at line 34
@naveedchaudhry2700Ай бұрын
It is very informative video. However, I am using VMWare software instead of Oracle VirtuaI Box and am not able to use putty from my source laptop to VMware machines. I have created two network adaptors as 1. Bridged - 192.168.119.131 2. Host-only - 10.10.10.131 How can I make it work for putty. Whenever I use ping command, it message says host is not reachable. Thanks in advance
@DB2_OracleАй бұрын
Try below Video kzread.info/dash/bejne/hJtrusyNf7jIis4.html
@user-tk1ht5ps1jАй бұрын
Your efforts are much appreciated. you got one more subscriber :) Very useful video. Thank you so much and waiting for the next session.
@morshedulislamriaad6496Ай бұрын
Can you tell me how you setup the environment? I'm new to DBA.
@DB2_OracleАй бұрын
First Install VirtualBox (Free for personal use) Then Download RedHat or Oracle Enterprise Linux (Free) Then install OS Then Download Oracle Database Software Then Install Oracle Software Then Create Oracle Database All of the Videos are available on my channel
@morshedulislamriaad6496Ай бұрын
@@DB2_Oracle ThankYou very much
@ShivaKumar-dn8zmАй бұрын
pls execute the each command that are mentioned in the sql scripts step by step so that we can see step by step execution and will get deeper understanding
@DB2_OracleАй бұрын
I want to make my videos shorter and hence did like this. People lose interest when Videos are too long.
@HKM_0295Ай бұрын
Can you make a vedios on how to connect the linux db2 after installation onwards, in same linux box only...
@ahmedmuhammed8232Ай бұрын
dear sir how can i contact with you ?
@thamaraipoo-rj3eoАй бұрын
Hi , i am getting this error when sending email from oracle database, 503 AUTH command used when not advertised. any idea... i don't have oracle wallet manager...
@suzannesellers7383Ай бұрын
I am wondering about the fact that the standby is loaded from the primary backup using restore without rolling forward. So the standby is in “roll forward pending ”. Now if you allow ROS, how can a read be done if the status is “roll forward pending “?
@AbdulAziz-yy3iuАй бұрын
Brother , you are the best. i have seen many tutorial of oracle but your representation is best. thank you so much. your tutorial have full completeness specially you share the scripts in description. thanks again.
@suzannesellers7383Ай бұрын
Excellent
@RamazanCetinkaya-tm1biАй бұрын
Is there any chance installing Purescale on CentOS Stream?
@DB2_OracleАй бұрын
I have not tried and I believe it will work. You might want to setup additional configuration. However this will not be supported by IBM.
@user-co4gu5zw9eАй бұрын
really appreciate! thank you so much!
@amanverma9691Ай бұрын
Hello, While creating the instance I am getting the below error: DBI20073E The specified command failed because the value specified for a keyword in the response file was invalid. Value: "Sam". Keyword: "inst1.NAME". DBI20073E The specified command failed because the value specified for a keyword in the response file was invalid. Value: "Sam". Keyword: "inst1.FENCED_USERNAME". Can you please help me fixing this issue at priority
@DB2_OracleАй бұрын
What command are you running?
@k.waugh21Ай бұрын
Nice tutorial. I found that the validation utility needs to run with domain permissions, else it returns an error when validating AD Configuration due to write permissions. Alternative is to prestage cluster object.
Пікірлер
I have only c drive can i extract there
Bro my change adapter settings not opening…
Bro, what can I do?
Great job and straight to the point.
Hi. I wanted to know that to install Enterprise manager agent on windows. Do we have to do these things first then install Agent or directly we can do that? Please answer me
👍 Thank you
Shut Abort Startup Mount Rman) restore Datafile 5 ; Rman) recover Datafile 5 ; SQL) Alter database open ; Would this work as well with the Datafile 5 online? Thank you !!
This will work. As you have put the database in MOUNT mode However if you want to restore datafile while database is online, you need to mark that datafile offline Use alter tablespace command before restore
sir from where can i download grid in video (unzip -qq oracle_DB_19cR300_Grid_LIN64_Home.ZIP -d /dbi/oracle/V19Grid) can you give me the link thank you
From the Oracle Website www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html
Very informative video. Keep up the great work!
Thank you
But brother clustering is for load balancing also thn how it is in active passive
Oracle RAC can be configured as ACTIVE-ACTIVE or ACTIVE-PASSIVE based on your choice.
Excellent and easy explanation! Really good video guide.
Many thanks from Palestine
On the second node, I tried to add th eip address to the target and when I clicked on quick connect, it does not work writing that no targets are available. Although it worked in the first node. Why is this?
please use black theme
Could you pls share the pdf doc?
Great content. What will happen if some reason the comunication between the nodes get lost and both nodes are PRIMARY, then after some time the connection got restored. In this case what will happen to the instances ? Is there a way to prioritize them so that one will remain as PRIMARY and the other one stops or fails ?
very good , it should be great to have a tutorial on the management of space disk (datafiles, filesystem etc) for databases
Coming Up. This is long due.
Very informative. Thank you
How i can download ibm cdc, where link. Without login to ibm
This does not use CDC. This uses only DB2
Great explanation of something I never knew before.
Excellent
installation got stuck in 62 % Logs INFO: oracle.sysman.top.oms:Renaming the file usermessaging.xml to usermessaging.xml INFO: oracle.sysman.top.oms:File is moved successful! INFO: oracle.sysman.top.oms:MDS Schema Creation status: COMPLETED INFO: oracle.sysman.top.oms:MDS Schema Creation is successful INFO: oracle.sysman.top.oms:_______________________________________________________________________ INFO: oracle.sysman.top.oms:Starting opss Schema Creation. INFO: oracle.sysman.top.oms:Debug: SCRIPT_HOME: null Can you help me out
Previously it got stuck in 54% during repo creation steps , issue got solve by running the below SQL> EXEC DBMS_STATS.unlock_schema_stats('SYSMAN'); SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SYSMAN');
👏👏👏👏 congratulations. Now you have to do one to REactivate the standby when it stops in the different cases.
Fantastic
Hi, I have an interview tomorrow. I can always depend on you for the information I need.
Best of luck for your interview
Hello Sir I need urgent assistance basically I downloaded both the 64 and 32 bit both are not working like when I click on setup and I confirm with yes a black screen shows for nano seconds and then vanishes what should I need to do sir
Which Operating system?
@@DB2_Oracle Sir on windows 7 ultra
@@DB2_Oracle Window 7 Sir
Why i restore incompatibility operating system
Don't understand the question?
@@DB2_Oracle do you any solution about backup from windows to linux database db2 ?
I need to award you 100000 stars
This means a lot. Thank You.
very nice explanation
00:03 DB2 HADR Rolling Upgrade 02:51 Promotion of subscribing to the channel 06:02 Subscribe to The Amazing 09:05 Subscription and activation process explained 11:10 Upgrading DB2 HADR 13:33 Update to-do list and subscribe to the main feed 15:34 Updating DB2 HADR to 11.54 meters distance 17:16 HADR Rolling Upgrade Crafted by Merlin AI.00:03 DB2 HADR Rolling Upgrade 02:51 Promotion of subscribing to the channel 06:02 Subscribe to The Amazing 09:05 Subscription and activation process explained 11:10 Upgrading DB2 HADR 13:33 Update to-do list and subscribe to the main feed 15:34 Updating DB2 HADR to 11.54 meters distance 17:16 HADR Rolling Upgrade Crafted by Merlin AI.00:03 DB2 HADR Rolling Upgrade 02:51 Promotion of subscribing to the channel 06:02 Subscribe to The Amazing 09:05 Subscription and activation process explained 11:10 Upgrading DB2 HADR 13:33 Update to-do list and subscribe to the main feed 15:34 Updating DB2 HADR to 11.54 meters distance 17:16 HADR Rolling Upgrade
Excellent tutorial. Very helpful to me, thank you very much.
Well done. Thanks
Can you share the script.... Thanks
If possible can you please upload the Doc which you are shoing in the Video ! Thank you for sharing valuble information.
Hello, I'm trying to carry out the process, but I'm stuck with an error (listed below). The certificates (I got them through the browser, these are the url I'm calling) are in Wallet and the one from the company I work for is also in Wallet. The ACL has also been configured. The digital certificates obtained by the browser have the .crt extension. ORA-29273: HTTP request failed ORA-29024: Certificate validation failure ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at line 34
It is very informative video. However, I am using VMWare software instead of Oracle VirtuaI Box and am not able to use putty from my source laptop to VMware machines. I have created two network adaptors as 1. Bridged - 192.168.119.131 2. Host-only - 10.10.10.131 How can I make it work for putty. Whenever I use ping command, it message says host is not reachable. Thanks in advance
Try below Video kzread.info/dash/bejne/hJtrusyNf7jIis4.html
Your efforts are much appreciated. you got one more subscriber :) Very useful video. Thank you so much and waiting for the next session.
Can you tell me how you setup the environment? I'm new to DBA.
First Install VirtualBox (Free for personal use) Then Download RedHat or Oracle Enterprise Linux (Free) Then install OS Then Download Oracle Database Software Then Install Oracle Software Then Create Oracle Database All of the Videos are available on my channel
@@DB2_Oracle ThankYou very much
pls execute the each command that are mentioned in the sql scripts step by step so that we can see step by step execution and will get deeper understanding
I want to make my videos shorter and hence did like this. People lose interest when Videos are too long.
Can you make a vedios on how to connect the linux db2 after installation onwards, in same linux box only...
dear sir how can i contact with you ?
Hi , i am getting this error when sending email from oracle database, 503 AUTH command used when not advertised. any idea... i don't have oracle wallet manager...
I am wondering about the fact that the standby is loaded from the primary backup using restore without rolling forward. So the standby is in “roll forward pending ”. Now if you allow ROS, how can a read be done if the status is “roll forward pending “?
Brother , you are the best. i have seen many tutorial of oracle but your representation is best. thank you so much. your tutorial have full completeness specially you share the scripts in description. thanks again.
Excellent
Is there any chance installing Purescale on CentOS Stream?
I have not tried and I believe it will work. You might want to setup additional configuration. However this will not be supported by IBM.
really appreciate! thank you so much!
Hello, While creating the instance I am getting the below error: DBI20073E The specified command failed because the value specified for a keyword in the response file was invalid. Value: "Sam". Keyword: "inst1.NAME". DBI20073E The specified command failed because the value specified for a keyword in the response file was invalid. Value: "Sam". Keyword: "inst1.FENCED_USERNAME". Can you please help me fixing this issue at priority
What command are you running?
Nice tutorial. I found that the validation utility needs to run with domain permissions, else it returns an error when validating AD Configuration due to write permissions. Alternative is to prestage cluster object.
Thank You for valuable information.
very informative