Тёмный
OCP TECHNOLOGY
OCP TECHNOLOGY
OCP TECHNOLOGY
Подписаться
OCP TECHNOLOGY
providing free Tutorials on ORACLE RDBMS software including ORACLE RAC (Real Application Cluster), ASM (Automatic Storage Management), Oracle DATAGUARD, SQL, PL/SQL
in Hindi & English Language so that everybody learns & understands quickly.
For business inquiries: support@ocptechnology.com
How to install Oracle 23c on Linux
8:33
5 месяцев назад
How to install windows server 2022
7:46
2 года назад
Комментарии
@melikeertunc6093
@melikeertunc6093 4 дня назад
hi! Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?
@ocptechnology
@ocptechnology 3 дня назад
@@melikeertunc6093 chang the date format in excel simple
@kindurudineshreddy-jr8uo
@kindurudineshreddy-jr8uo 10 дней назад
Tq nice explanation
@isvic007
@isvic007 10 дней назад
My database is 50tb, archive generation is 20tb per day. If I have to bring back my primary after a week, what would be the flashback space requirement?
@ocptechnology
@ocptechnology 7 дней назад
You can calculate the required FRA size as per daily archives generation dear
@rowlandjones3872
@rowlandjones3872 11 дней назад
Hi i didnt see you or hear you mention that the preupgrade.jar file needs to be downloaded?? Or its not important for these steps
@ocptechnology
@ocptechnology 11 дней назад
Have you seen the complete video?
@mylittleguggu4786
@mylittleguggu4786 12 дней назад
Hi Bro, I have doubt, i have EBS 12.2 with 19c (CDB, PDB) database. I need to make this primary & standby. I have new standby server. In standby server do we need to copy Primary database Oracle_Home? and how they create CDB & PDB in Secondary Server? Please explain me.
@ocptechnology
@ocptechnology 12 дней назад
Hi, First install the same version of oracle database on standby server then take rman backup on primary db once it's completed then restore it on standby but before restoration set Datagurd parameters on primary db, check Datagurd video on our channel
@armenhagobian
@armenhagobian 24 дня назад
Thank you so much for sharing on how to create a mount in a Linux server...
@ocptechnology
@ocptechnology 20 дней назад
Welcome dear
@shreyashpatil7648
@shreyashpatil7648 29 дней назад
Thank you sir it is very helpful
@ocptechnology
@ocptechnology 29 дней назад
Welcome dear
@shreyashpatil7648
@shreyashpatil7648 Месяц назад
Very informative straight to the point that's why I always prefer to watch your videos
@ocptechnology
@ocptechnology Месяц назад
Thank you dear
@Shazrash
@Shazrash Месяц назад
Hello everyone who can help me in oracle dba bcz i m stuck here please help me who is doing work as a oracle dba
@ocptechnology
@ocptechnology Месяц назад
Hi, Where you stuck?
@awkhanabdul1313
@awkhanabdul1313 Месяц назад
super explanation
@ocptechnology
@ocptechnology Месяц назад
Thanks dear
@awkhanabdul1313
@awkhanabdul1313 Месяц назад
Super explanations DG steps
@ocptechnology
@ocptechnology Месяц назад
Thank you dear
@Shazrash
@Shazrash Месяц назад
Anyone is there who will help me in solve the oracle issue
@ocptechnology
@ocptechnology Месяц назад
What issue are you facing?
@shreyashpatil7648
@shreyashpatil7648 Месяц назад
Thanks sir it helpful
@user-yr1vz2po9y
@user-yr1vz2po9y Месяц назад
thanks it was helpful
@ocptechnology
@ocptechnology Месяц назад
Thanks dear
@imtiazmahmood1757
@imtiazmahmood1757 Месяц назад
Sir I wished to know if at source I have 18.0.0, and at destination 19c. So then how do I perform datapump
@ocptechnology
@ocptechnology 11 дней назад
Simple bro just take export from 18c and import in 19c
@iamsonu123
@iamsonu123 Месяц назад
Sir aap hindi me bhi pdha diya karo....aap ka pdhaya hua ache se samjah me aata h. or app (LEARNOMATE TECHNOLOGY) se acha padhate ho...all videos Awesome sir
@ocptechnology
@ocptechnology Месяц назад
Thank you bro
@balajichandramohan5117
@balajichandramohan5117 Месяц назад
Hi sir, if 'alter database commit to switchover to primary' is the command for failover then what is the command for switchover?
@ocptechnology
@ocptechnology 11 дней назад
Same command bro
@viniciusrw
@viniciusrw Месяц назад
Hello, I tried just following your steps, but when I run $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql, received : ERROR at line 13: ORA-00942: table or view does not exist SQL> SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE 2 ; SELECT TO_NUMBER('NONUPGRADED_TABLEDATA') FROM SYS.V$INSTANCE * ERROR at line 1: ORA-01722: invalid number In my original database I did not run any pre-upgrade script, should I run it before performing the backup to correct these errors?
@ocptechnology
@ocptechnology Месяц назад
Yes, you should create backup
@viniciusrw
@viniciusrw Месяц назад
@@ocptechnology Hello, I'm a bit of a detail oriented person, so I should run the scripts on the source base and then proceed with the backup to restore on the destination base, right?
@muhammadjabirsalman8128
@muhammadjabirsalman8128 Месяц назад
Wonderfull video, is it work windows as well??
@ocptechnology
@ocptechnology Месяц назад
Thank you dear
@Yuka2003n
@Yuka2003n Месяц назад
One more thing about the connection. I modified the tnsnames.ora file by adding the service FREEPDB1 (listener.ora about FREEPDB1 was also added the difference from yours is that when started, bother services, FREE and FREEPDB1 are UNKNOWN instead of READY). When login sys as sysdba@FREEPDB1, I had the ORA-01017 error.
@Yuka2003n
@Yuka2003n Месяц назад
I have the Listener start problem. There is no error messages. However, when started, yours are "READY" whereas mine is "UNKNOWN". Do you know what is the problem of causing that?
@ocptechnology
@ocptechnology Месяц назад
Register the Database service with the listener then try
@rahithreddy4704
@rahithreddy4704 2 месяца назад
Mail id to contact you
@rahithreddy4704
@rahithreddy4704 2 месяца назад
Hi sripal ji pls send me your contact number
@user-vh2ym6ff9w
@user-vh2ym6ff9w 2 месяца назад
You are genius
@ocptechnology
@ocptechnology 2 месяца назад
Thank you dear
@yosephfahed9897
@yosephfahed9897 2 месяца назад
Thank you very much, very helpfull
@ocptechnology
@ocptechnology 2 месяца назад
Your welcome bro
@supreethgr2586
@supreethgr2586 2 месяца назад
Could you please make video on how to enable TLS 1.3 on Oracle 23c Linux or RHEL? Not getting any resource. Thanks
@nihlanijam5145
@nihlanijam5145 2 месяца назад
Thank You Sir!!!!
@ocptechnology
@ocptechnology 2 месяца назад
Your welcome
@robertdeutschmann578
@robertdeutschmann578 3 месяца назад
many thanks for your efforts to share this informative video with us😃
@ocptechnology
@ocptechnology 3 месяца назад
Thanks for watching #ocptechnology
@kknirala1
@kknirala1 3 месяца назад
Great job dear..
@ocptechnology
@ocptechnology 3 месяца назад
Thank you dear
@jeevananthamvaradhan2596
@jeevananthamvaradhan2596 3 месяца назад
Super ji
@ocptechnology
@ocptechnology 3 месяца назад
Thank you 🙏
@Venkatesh-Venky
@Venkatesh-Venky 3 месяца назад
Good content 👌 bro😊
@Venkatesh-Venky
@Venkatesh-Venky 3 месяца назад
Make a video 📹 optimizer statistics bro
@ocptechnology
@ocptechnology 2 месяца назад
Ok coming soon
@Venkatesh-Venky
@Venkatesh-Venky 3 месяца назад
No clarity voice bro
@ocptechnology
@ocptechnology 3 месяца назад
Thanks for watching bro. In next video I'll try to record with good quality audio
@Venkatesh-Venky
@Venkatesh-Venky 3 месяца назад
​@@ocptechnology OK 👍 tq bro
@fernandomartinsdasilva3164
@fernandomartinsdasilva3164 3 месяца назад
Very good my friend , I just following you, I’m from Brazil
@ocptechnology
@ocptechnology 3 месяца назад
Thank you dear
@Super3tube
@Super3tube 3 месяца назад
Good understanding of the concept.🎉
@ocptechnology
@ocptechnology 3 месяца назад
Thank you
@SiegbertMashika
@SiegbertMashika 3 месяца назад
Good day Shripal, Thank you for this helpful video2, I wanted to ask. what if my CDB is on a different server does that mean i have to copy the database files in one location on the CDB , in order to specify the locations in COPY FILE_NAME_CONVERT parameters? In my case i do have the NON CDB datafiles in different locations as well.
@ocptechnology
@ocptechnology 3 месяца назад
Thanks for watching, you can try but on UAT, I never try this
@vickynagpal6574
@vickynagpal6574 6 дней назад
@@ocptechnology Thank you. I have the same scenario wherein My non cdb is on anther box and new CDB (PDB) is on another. Should we take the cold backup after creating the xml to new server and then convert?
@chaitanyalotwala8796
@chaitanyalotwala8796 3 месяца назад
Very crisp and "To The Point" explaination..!! another helpful video from you..!!
@ocptechnology
@ocptechnology 3 месяца назад
Thank you chaitanya
@colorsoflife-811
@colorsoflife-811 3 месяца назад
Thanks dear
@ocptechnology
@ocptechnology 3 месяца назад
Your welcome
@lifesaint
@lifesaint 4 месяца назад
I understand Oracle has CDB, if we add another database in 11g, will it be CDB or PDB (I know 11g does not support PDB, but can't be two CDB, right?)
@ocptechnology
@ocptechnology 4 месяца назад
It will be kind of PDB, but not actually pdb
@gajanandn
@gajanandn 4 месяца назад
It wont work if i try to peroform the datapump activity from 10g to 19c ... highly appreciated if any buddy can support
@nicholusnatweta2942
@nicholusnatweta2942 4 месяца назад
can you a video on rman restore please? especially from recovery catalog. Thanks
@samtheoyou
@samtheoyou 4 месяца назад
is that same for 19c RAC env
@ocptechnology
@ocptechnology 4 месяца назад
A little bit different, please read the readme file carefully
@moldovanmoldovan7593
@moldovanmoldovan7593 4 месяца назад
Namaste, Shripal. I still do not get it, are you using two DISTINCT Oracle database instances (but with same major/minor version) or you somehow do convert Non-CDB to CDB using same Oracle instance? thanks
@ocptechnology
@ocptechnology 4 месяца назад
There are two different instances
@guruprasadmahajan605
@guruprasadmahajan605 4 месяца назад
How to connect with you
@ocptechnology
@ocptechnology 4 месяца назад
support@ocptechnology.com our official mail
@user-zr1ce3oj7b
@user-zr1ce3oj7b 4 месяца назад
More description needed
@ocptechnology
@ocptechnology 4 месяца назад
Ok, can you share what you want to know?
@sadanb4876
@sadanb4876 4 месяца назад
Nice video sir... please do video on RMAN DUPLICATE on ASM ?
@ocptechnology
@ocptechnology 4 месяца назад
Thanks sadan, i'll upload soon
@vipulsharma7658
@vipulsharma7658 4 месяца назад
Awesome video, explanation part is best.
@ocptechnology
@ocptechnology 4 месяца назад
Thank you bro