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: [email protected]
Пікірлер
Thank you so much for sharing on how to create a mount in a Linux server...
Welcome dear
Thank you sir it is very helpful
Welcome dear
Very informative straight to the point that's why I always prefer to watch your videos
Thank you dear
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
Hi, Where you stuck?
super explanation
Thanks dear
Super explanations DG steps
Thank you dear
Anyone is there who will help me in solve the oracle issue
What issue are you facing?
Thanks sir it helpful
thanks it was helpful
Thanks dear
Sir I wished to know if at source I have 18.0.0, and at destination 19c. So then how do I perform datapump
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
Thank you bro
Hi sir, if 'alter database commit to switchover to primary' is the command for failover then what is the command for switchover?
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?
Yes, you should create backup
@@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?
Wonderfull video, is it work windows as well??
Thank you dear
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.
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?
Register the Database service with the listener then try
Mail id to contact you
Hi sripal ji pls send me your contact number
You are genius
Thank you dear
Thank you very much, very helpfull
Your welcome bro
Could you please make video on how to enable TLS 1.3 on Oracle 23c Linux or RHEL? Not getting any resource. Thanks
Thank You Sir!!!!
Your welcome
many thanks for your efforts to share this informative video with us😃
Thanks for watching #ocptechnology
Great job dear..
Thank you dear
Super ji
Thank you 🙏
Good content 👌 bro😊
Make a video 📹 optimizer statistics bro
Ok coming soon
No clarity voice bro
Thanks for watching bro. In next video I'll try to record with good quality audio
@@ocptechnology OK 👍 tq bro
Very good my friend , I just following you, I’m from Brazil
Thank you dear
Good understanding of the concept.🎉
Thank you
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.
Thanks for watching, you can try but on UAT, I never try this
Very crisp and "To The Point" explaination..!! another helpful video from you..!!
Thank you chaitanya
Thanks dear
Your welcome
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?)
It will be kind of PDB, but not actually pdb
It wont work if i try to peroform the datapump activity from 10g to 19c ... highly appreciated if any buddy can support
can you a video on rman restore please? especially from recovery catalog. Thanks
is that same for 19c RAC env
A little bit different, please read the readme file carefully
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
There are two different instances
How to connect with you
[email protected] our official mail
More description needed
Ok, can you share what you want to know?
Nice video sir... please do video on RMAN DUPLICATE on ASM ?
Thanks sadan, i'll upload soon
Awesome video, explanation part is best.
Thank you bro
Great video
Thanks!
Bro apki yt earning chalu ho gayi kya?
Kyo puch rehe ho bhai?
@@ocptechnology views or subs k base pr puch rha hu
@@ocptechnology kunki ads bhi AA rhi h. Apke videos pr
@@ocptechnologywhy this oracle 23c free version has 12gb ram limit while the free oracle 21c production version has no ram limit? Have they changed there plans?
@@jirehla-ab1671 yes, they changed in plans, for more information need to read license documents
Hi sir, how can we get the graphical interface Display from the Linux command prompt.
Linux always have command prompt and gui interface just logged in and take gui
hi i install the oracle 19c but create the database that timr getting error TNS -04415. i allready install the oracle 11g . but iwant to install also 19c is it possible then kindly help us
Pradeep once 19c installation was completed, then set the 19c environment then run dbca and uncheck the OEM option
Helpful😊
Thank you