- 28
- 59 554
Ni TSOH
United States
เข้าร่วมเมื่อ 24 พ.ย. 2008
I am an Oracle enthusiast sharing with you Oracle related content for personal and professional development.
My focus on this channel is on Oracle Database Administration across several version and platforms.
My focus on this channel is on Oracle Database Administration across several version and platforms.
Oracle Database: ORA 03113 end of file on communication channel
Oracle Database: ORA 03113 end of file on communication channel
ORA 03113 end of file on communication channel
What does an ORA-03113: end-of-file on communication channel mean?
This is a generic error that can mean many things.
however, if you get this error, it means there is a broken connection between some client process and some server process and it needs further investigation.
Diagnosing:
- Check database alert log
- Investigate the Fast Recovery Area Usage:
SELECT SPACE_LIMIT/1024/1024 "LIMIT_MB", SPACE_USED/1024/1024 "USAGE_MB", (SPACE_LIMIT - SPACE_USED)/1024/1024 "FREE_MB" FROM V$RECOVERY_FILE_DEST;
- Increase FRA size:
ALTER SYSTEM SET =XX SCOPE=BOTH SID='*';
- Manage space in FRA to prevent reoccurrence
Follow me:
----------
LinkedIn: www.linkedin.com/in/atsohmofor/
Twitter: Bindag OR @Bindag
email: bobsukki@gmail.com
Telegram: NI TSOH
TH-cam: th-cam.com/channels/x06.html... OR NI TSOH
ORA 03113 end of file on communication channel
What does an ORA-03113: end-of-file on communication channel mean?
This is a generic error that can mean many things.
however, if you get this error, it means there is a broken connection between some client process and some server process and it needs further investigation.
Diagnosing:
- Check database alert log
- Investigate the Fast Recovery Area Usage:
SELECT SPACE_LIMIT/1024/1024 "LIMIT_MB", SPACE_USED/1024/1024 "USAGE_MB", (SPACE_LIMIT - SPACE_USED)/1024/1024 "FREE_MB" FROM V$RECOVERY_FILE_DEST;
- Increase FRA size:
ALTER SYSTEM SET =XX SCOPE=BOTH SID='*';
- Manage space in FRA to prevent reoccurrence
Follow me:
----------
LinkedIn: www.linkedin.com/in/atsohmofor/
Twitter: Bindag OR @Bindag
email: bobsukki@gmail.com
Telegram: NI TSOH
TH-cam: th-cam.com/channels/x06.html... OR NI TSOH
มุมมอง: 5 196
วีดีโอ
Oracle Database: Oracle SQL Define Editor
มุมมอง 5582 ปีที่แล้ว
Oracle SQL Define Editor For Oracle Database Administrators and Oracle SQL Developers Option 1: SQL*plus: define_editor=vi However, this is not persistent across user sessions Option 2: edit the glogin.sql global login site profile file vi $ORACLE_HOME/sqlplus/admin/glogin.sql add the line define_editor=vi This is persistent across user sessions #oracle #sql #database #dba
Oracle Database: Oracle SGA Memory Advisor
มุมมอง 2.8K2 ปีที่แล้ว
Oracle SGA Memory Advisor. Oracle Database: SGA Memory Advisor Resolving Error ORA-4031 on the Shared Pool ORA-4031 unable to allocate XX bytes of shared memory When memory is requested by the shared pool, an attempt to allocate a large piece of contiguous memory in the shared pool is made. However, When that attempt fails: - Oracle first flushes all objects that are not currently in use from t...
Oracle Database: Oracle Row Lock Contention
มุมมอง 2.4K2 ปีที่แล้ว
Oracle Database Row Lock Contention Oracle Row Lock Contention Database row lock contention LOCKS: - Locks are used by Oracle databases to provide data concurrency and integrity between transactions. - Locking within an Oracle database is an entirely automatic mechanism that prevent destructive interaction between transactions accessing the same resource - There are several levels to locking, b...
Oracle Multitenant Architecture: CDB vs Non CDB
มุมมอง 1.2K2 ปีที่แล้ว
#oracle #multitenant #pluggable #cdb #pdb #database Oracle Multitenant Architecture CDB vs Non CDB Oracle Multitenant Architecture, The only supported architecture from Oracle Database 21c Oracle plans to DeSupport Non-CDB from 21c onward Here are 2 videos on how to setup a Playground environment: 1. Intro Part 1: Oracle Linux 7.3 Server Installation VirtualBox th-cam.com/video/UBQSfoyzNYI/w-d-...
RMAN INCREMENTAL BACKUP Differential vs Cumulative
มุมมอง 1K2 ปีที่แล้ว
RMAN INCREMENTAL BACKUP #oracle #database #rman #backup #recovery #freetraining #incremental #differential #cumulative Oracle Database RMAN INCREMENTAL BACKUP STRATEGY Differential vs Cumulative RMAN INCREMENTAL BACKUP STRATEGY Differential VS Cumulative Backup Options: - User managed backups - RMAN backups - Many different options - Logical backups - Data Pump RMAN Incremental Backups An incre...
Oracle Database Security Assessment
มุมมอง 1.3K2 ปีที่แล้ว
Oracle Database Security Assessment Tool Oracle Database Audit Oracle Database Security Assessment Tool Oracle Database: Database Audit using the Oracle Database Security Assessment Tool (DBSAT) #security #oracle #compliance #database #audit The Oracle DBSAT consists of the following components: Collector: The Collector executes SQL queries and runs operating system commands to collect data fro...
Oracle Database: Data Guard SWITCHOVER using Manual Method (SQL) and DG Broker Method (DGMGRL)
มุมมอง 1.6K2 ปีที่แล้ว
Oracle Database: Data Guard SWITCHOVER using Manual Method (SQL*Plus) and DG Broker Method (DGMGRL) Related Videos: Oracle Database 19c Step By Step Data Guard Configuration with Data Guard Broker th-cam.com/video/e3r97b5C2A4/w-d-xo.html Oracle Database: Data Guard - Single Instance Primary to RAC Standby with DG Broker th-cam.com/video/rqnBqc2YEyE/w-d-xo.html Follow me: LinkedIn: www.linkedin....
Oracle Database How to uninstall an ORACLE_HOME using the deinstall tool
มุมมอง 1.1K2 ปีที่แล้ว
Oracle Database How to deinstall an ORACLE_HOME using the deinstall tool #oracle #database #deinstall #ORACLE_HOME deinstall oracle Follow me: LinkedIn: www.linkedin.com/in/atsohmofor/ Twitter: Bindag OR @Bindag email: bobsukki@gmail.com Telegram: NI TSOH TH-cam: th-cam.com/channels/x06dllvcDWc5yyFVqVdFPA.html OR NI TSOH
Introduction to Structured Query Language SQL Oracle Database
มุมมอง 5462 ปีที่แล้ว
Introduction to Structured Query Language Oracle Database Intro to SQL - Data Definition Language / Data Manipulation Language / Transaction Control Language DDL/DML/TCL DDL - CREATE, ALTER, DROP, TRUNCATE DML - SELECT, INSERT, UPDATE, DELETE TCL - COMMIT, SAVEPOINT, ROLLBACK #sql #oracle # #ddl #dml #database #tcl Related Videos: How to establish a BASIC SQL Developer connection to an Oracle D...
Oracle Database: Data Guard - Single Instance Primary to RAC Standby with DG Broker
มุมมอง 3.4K2 ปีที่แล้ว
Oracle Database: Data Guard - Single Instance Primary to RAC Standby with DG Broker Related Videos: Oracle Database Convert Single Instance to RAC using rconfig utility th-cam.com/video/3OSyx1dNqUE/w-d-xo.html Oracle Database 19c Step By Step Data Guard Configuration with Data Guard Broker th-cam.com/video/e3r97b5C2A4/w-d-xo.html Follow me: LinkedIn: www.linkedin.com/in/atsohmofor/ Twitter: twi...
Oracle Database Convert Single Instance to RAC using rconfig utility
มุมมอง 1.4K2 ปีที่แล้ว
Oracle Database Convert Single Instance to RAC using rconfig utility #database #oracle #rconfig #RAC Follow me: LinkedIn: www.linkedin.com/in/atsohmofor/ Twitter: Bindag OR @Bindag email: bobsukki@gmail.com Telegram: NI TSOH TH-cam: th-cam.com/channels/x06dllvcDWc5yyFVqVdFPA.html OR NI TSOH
Oracle Database 19c REFRESH using RMAN and DATA PUMP
มุมมอง 7K2 ปีที่แล้ว
Oracle Database 19c REFRESH using RMAN and DATA PUMP #oracle #refresh #rman Related Videos: Oracle Database: ACTIVE Database DUPLICATION using RMAN th-cam.com/video/oDfPIuaigoY/w-d-xo.html How to establish a BASIC SQL Developer connection to an Oracle Database th-cam.com/video/gisJY0fmqf0/w-d-xo.html Oracle Database 11gR2 Migration/Upgrade to 19c using Data Pump th-cam.com/video/JYMRpgEJ5lc/w-d...
Oracle Database: ACTIVE Database DUPLICATION using RMAN
มุมมอง 2.7K2 ปีที่แล้ว
Related Video: Oracle RAC Part 2: Clone VM, configure hostname and network settings th-cam.com/video/nTKXj_4A8l4/w-d-xo.html #rman #duplication #oracle #clone Follow me: LinkedIn: www.linkedin.com/in/atsohmofor/ Twitter: Bindag OR @Bindag email: bobsukki@gmail.com Telegram: NI TSOH TH-cam: th-cam.com/channels/x06dllvcDWc5yyFVqVdFPA.html OR NI TSOH Oracle Database: ACTIVE Database DU...
Oracle Database 11gR2 Migration/Upgrade to 19c using Data Pump
มุมมอง 8K2 ปีที่แล้ว
Oracle Database 11gR2 migration/upgrade to 19c using Data Pump Related Videos: How to establish a BASIC SQL Developer connection to an Oracle Database th-cam.com/video/gisJY0fmqf0/w-d-xo.html Follow me: LinkedIn: www.linkedin.com/in/atsohmofor/ Twitter: Bindag OR @Bindag email: bobsukki@gmail.com Telegram: NI TSOH TH-cam: th-cam.com/channels/x06dllvcDWc5yyFVqVdFPA.html OR NI TSOH Re...
Oracle Database 19c Step By Step Data Guard Configuration with Data Guard Broker
มุมมอง 3.4K2 ปีที่แล้ว
Oracle Database 19c Step By Step Data Guard Configuration with Data Guard Broker
Oracle RAC Part 5 of 5: Configure Oracle 12c RAC Database
มุมมอง 8522 ปีที่แล้ว
Oracle RAC Part 5 of 5: Configure Oracle 12c RAC Database
Oracle RAC Part 4 of 5: Oracle Grid Infrastructure 12c Installation
มุมมอง 1.3K2 ปีที่แล้ว
Oracle RAC Part 4 of 5: Oracle Grid Infrastructure 12c Installation
Oracle RAC Part 3 of 5: Allocate and Configure Shared Storage for ASM
มุมมอง 9942 ปีที่แล้ว
Oracle RAC Part 3 of 5: Allocate and Configure Shared Storage for ASM
Oracle RAC Part 2 of 5: Clone VM, configure hostname and network settings
มุมมอง 1K2 ปีที่แล้ว
Oracle RAC Part 2 of 5: Clone VM, configure hostname and network settings
Oracle RAC Part 1 of 5: Configuration Oracle Linux 7 Server with 3 Network interfaces
มุมมอง 1.7K2 ปีที่แล้ว
Oracle RAC Part 1 of 5: Configuration Oracle Linux 7 Server with 3 Network interfaces
How To Switch to Archivelog Mode - Oracle Database
มุมมอง 6932 ปีที่แล้ว
How To Switch to Archivelog Mode - Oracle Database
How to establish a BASIC SQL Developer connection to an Oracle Database
มุมมอง 8252 ปีที่แล้ว
How to establish a BASIC SQL Developer connection to an Oracle Database
Upgrade 12c - 19c AUTOUPGRADE Method. How to Upgrade Multiple Oracle Database at the same time!
มุมมอง 3.6K2 ปีที่แล้ว
Upgrade 12c - 19c AUTOUPGRADE Method. How to Upgrade Multiple Oracle Database at the same time!
Upgrade 12cR2 Database to 19c - Part 2 DBUA
มุมมอง 9542 ปีที่แล้ว
Upgrade 12cR2 Database to 19c - Part 2 DBUA
Oracle Database Upgrade 12c to 19c - Part1: 19c Installation on Oracle Linux 7
มุมมอง 1.4K3 ปีที่แล้ว
Oracle Database Upgrade 12c to 19c - Part1: 19c Installation on Oracle Linux 7
Intro Part 2: Oracle Database 12cR2 Installation and Configuration Linux 7 Server
มุมมอง 9453 ปีที่แล้ว
Intro Part 2: Oracle Database 12cR2 Installation and Configuration Linux 7 Server
Intro Part 1: Oracle Linux 7.3 Server Installation VirtualBox
มุมมอง 1.3K3 ปีที่แล้ว
Intro Part 1: Oracle Linux 7.3 Server Installation VirtualBox
Very Good presentation.
I appreciate your feedback!
really good material, thanks
Thank you for this ORA 03113 video! It was exactly what I needed and solved my issue perfectly. Now my database is in READ WRITE mode. Keep up the great work!
Glad it helped!
Can you paste the sql statements on here somewhere
Since these are simple statements, would you be able to just follow and copy onto your SQL prompt? Unfortunately, I did not include these in the transcript
Good stuff!
Thanks!
It's really great learning. It's my request can you please share upgrade 12c to 19c database. And also patching the RAC & standalone database.
Please follow this video for 12c to 19c upgrade using autoupgrade th-cam.com/video/CxJZPOXt9PU/w-d-xo.html
Is role automatically created on target or will be created manually?
Is this method feeasible for 7TB db?
I would not recommend this method for large databases as this will require alot of time for the exp and imp processes. If you choose to, it will require alot of resources and parallelism
Got clarity about nofilename check command in this video thanks a lot
Glad it helped 👍🏽
Can u help me?
Yes I hope I can. Send me a message on LinkedIn
Follow me on LinkedIn (pinned comment ) and send me a message
YOU RESOLVE MY PROBLEM TYSM !!!
Could you please paste those sql statements here sir
Did he paste those SQL statements on here?
Great Very good explanation.
Your video helps me a lot. Thank you so much. Respected Sir
where are you? hope you are doing well, you have a great channel! please drop more contents!
I appreciate! 👍
How can I get this documentation you use?
Thnq
very informative, Hi Sir Your vedios are very good and helpful for us.
Great
Hands-down the most straightforward and simplest guide to setting up DG and the DB Broker I have seen. Thanks for taking the time to make this video! Oracle of course provides no step-by-step guide, so you are on your own to piece together a script to make this all work. There are many things I've been including based on various other guides that appear to not be necessary, possibly because they are based on older db versions items that are no longer required (such as a separate listener entry for the broker).
Hi, from the demo, does it mean decreasing the SGA to factor of .5 will have better performance as the estimate db time is 20?
plz share the video of stand by db
Here you go... th-cam.com/video/e3r97b5C2A4/w-d-xo.html
Great video bro keep on uploading new videos on Oracle DB
Thank you!
Can you also make a video on rman refresh when source and target is container database consisting of single pdb ?
Thank you very much for this video...Can you also make one on setting PGA using advisor
Excellent videos.m please make a course on 19c multenant on udemy or youtube
I appreciate your suggestion, it will be an absolutely great idea! Thank you
THANKS🙂
i thought we should also create logfile thread 2 and undotbs2 on primary...
You're absolutely one of the best I've ever watched.
Thank you! I appreciate
Fantastic! Could you please do an extensive video on "Performance Tuning?" maybe with OEM 13.5 cloud or alternatives. Thank you so much.
Simple and straigthforward .. great info
wow this was awesome, I couldn't believe you provided these 5 videos for free I see lots charging $5k for series like these. Thanks
You're very welcome!
I did everything step by step but I couldn't connect to auxiliary database in RMAN, ,(Instance "primtstDB", status BLOCKED, has 1 handler(s) for this service. ) . RMAN> connect auxiliary sys@primtst; auxiliary database Password: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-04006: error from auxiliary database: ORA-12537: TNS:connection closed
Thanks I resolve this error by adding additional entry into my tnsnames.ora file, in the last line entry after service_name, I added this " (UR = A) ". For anyone having this error try this, it should work. :)
Amazing. love it. Why dont you source those parameters from the bash_profile?
I could, but i usually don't prefer using the bash_profile when I plan on having multiple databases running on thesame server
Very well presented. You are a great content creator and instructor. The steps are clear easy to follow but I wish you could include some other pre-requisite steps like hosts file edit, distinction between manual and automatic install parameters, maybe mention solutions to some commonly experienced installation processes. Thank you.
Noted
Can you help me i already following ur step but when i try to connect to rman auxiliary "dbstby" my tns couldnt connect the server and i see listener status on standby its blocked
Sorry I am getting to you late... Do you still have this issue going on?
I have 2 questions 1)Do we need to install Clusterware on node 2 before converting to RAC or rconfig will take care of it. 2)What if the second node has configuration issues, and how rconfig will take care of it ?
Ans 1: YES YES and YES... RAC is clustered nodes... so Clusterware must be installed. Ans2: rconfig is only a tool to help convert SI to RAC... if there are underlying issues, rconfig more than likely will fail. That is why you run rconfig with ONLY option to check first before executing
very nicely explained and very much informative
Glad it was helpful!
is it just enough if I exclude just SYS and SYSTEM schemas?
Yes you can! 👌🏽
I enjoyed this video. valued added, you made my day
Glad you enjoyed it!
Should we be doing export and import as sysdba? I thought oracle does not recommend this?
Yes we can, it depends, especially when I am doing a Full=Y. Otherwise, use the SYSTEM user
As you are excluding most of the schemas , do we need full=y export? Why not just export(include) the application schema only (must smaller list) and thats it, instead of having a long list of excluded shemas? Your thoughts much appreciated. Thank you
You could do that too.
Great video thank you for sharing sir. Out of interest what about roles and privaleges or anything , will they be included the export/import? Secondly instead of creating a new dump directory can we not use the one already there? thank you
Yes, absolutely
Great insights, thanks for sharing!
Thank you always Chetan!
I don't show out the information of sensitive data in Discoverer, can you help me with this section?
Send me an email so we can find some time to connect and walk through
@@bobsukki I send
Sir The steps was very clear Much respect Please more videos on performance tuning , read awr, reading execution plan and sql tuning
Sure I will. Thank you
Does it requires downtime while going conversion .If no will it impact any new connection or existing connection ?
Great question... Yes, the single instance is shutdown and restarted multiple times and a new rac instance is created. Therefore, existing connections will be dropped as that single instance goes down
Respected Sir Your steps are very clear Thanks
Thank you Salad, I am glad you found it helpful!
@@bobsukki respected sir I can't wait your upcoming videos
Man you are doing great job A big thanks to sir
Thanks and welcome
Man you are doing great job Please do more videos on oracle performance tuning Please and please
Certainly, I will be making short performance tuning videos as requested!