Mallik034-OracleWorld

29/10/2024

Spfile Missing - Create spfile from pfile || FS database

Spfile Missing - Create spfile from pfile || FS database
https://www.youtube.com/watch?v=6Kx3HZBsEPg&t=34s

Spfile Missing - Create from pfile - FS / OracleRestart / RAC https://mallik034.blogspot.com/2024/03/spfile-missing-create-from-pfile-fs.html

1. spfile missing - create spfile from pfile - FS
2. spfile missing - create spfile from pfile - Oracle Restart
3. spfile missing - create spfile from pfile - RAC

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Spfile Missing - Create from pfile - FS / OracleRestart / RAChttps://mallik034.blogspot.com/2024/03/spfile-missing-create-from-pfile-fs.htmlUpcoming Batch Sc...

18/10/2024

New RAC Batch is starting on 18-Oct-2024, Saturday!!!
If you are interested in this Batch, Reach out to me on my Cell/WhatsApp number:

WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079

Please refer the below Recorded Demo Sessions:
Day_1_Demo_Session | RAC Course | RAC Architecture & RAC Networking
https://youtu.be/7MuSHOwZxb4?si=uqLFXXHAe6KeB7ez

Day_2_Demo_Session | RAC Course | RAC Maintenance & RAC File System & RAC Administration
https://youtu.be/vmmUseU1r-s?si=j_0a-bX6B17_yiTo

Please refer the below Course Details:
Weekend Batch: Saturday & Sunday only
Time: 08:30 AM IST to 12:30 PM IST (11:00 PM EST to 03:00 AM EST) (4 hour on weekends)
Duration: 5 Weekends
RAC Course fees: 15K INR (185 USD)
Mode: Online Live Classes over a zoom
Oracle Version: 19c Version

Course Curriculum:
https://mallik034.blogspot.com/p/rac-training.html

Register Here:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html

Refer here for more details:
https://docs.google.com/document/d/1yvl0poxtbv_B_N3KxVAM50nLTB0iKJEd0eb26Bg5K6g/edit

hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag hashtag

Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

15/10/2024

Useful ADRCI Commands In Oracle
https://youtu.be/FxLMHtqgmcY?si=PgOegjztmJBmrS8_

ADRCI Commands In Oracle
https://mallik034.blogspot.com/2024/03/adrci-in-oracle.html

1. Get current base location:(Its known as ADR_BASE)
2. Set new ORACLE_BASE(ADR_BASE)
3. List current ORACLE_HOME
4. Set new ORACLE_HOME
5. View alert log
6. Purge alerts and trace files
7. Set control policy for auto purge of files
8 . Create incident package
9. Unpack a ips file
10. Pack all incident files within a particular time frame
11. View package information
12. Remove/delete package information

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

ADRCI In OracleUseful ADRCI Commands In Oraclehttps://mallik034.blogspot.com/2024/03/adrci-in-oracle.htmlUpcoming Batch Schedule link:https://mallik034.blogs...

14/10/2024

Automation Script To Find the ASM Directory & Subdirectory Usage
https://www.youtube.com/watch?v=I5Ih35cEDVI

Automation Script To Find the ASM diskgroup directory & Subdirectory Usage https://mallik034.blogspot.com/2024/03/automation-script-to-find-asm-diskgroup.html
Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html


Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Automation Script To Find the ASM diskgroup directory & Subdirectory Usagehttps://mallik034.blogspot.com/2024/03/automation-script-to-find-asm-diskgroup.html...

13/10/2024

Automation Script | Archive Log Deletion
https://www.youtube.com/watch?v=_mnB2_SNDUg
Automation Script | Archive Log Deletion https://mallik034.blogspot.com/2024/04/automation-script-archive-log-deletion.html

1. List all the database running on the server
2. Check the archivelog deletion script scheduled via crontab job which is scheduled to run every Sunday
3. Archive log deletion script
4. On-demand ex*****on of the archive log deletion script

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Automation Script | Archive Log Deletionhttps://mallik034.blogspot.com/2024/04/automation-script-archive-log-deletion.htmlUpcoming Batch Schedule link:https:...

12/10/2024

Happy Dussehra 2024!!!

Happy Dussehra! May this festival bring peace, prosperity, and happiness to you and your loved ones.



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

12/10/2024

Automation Script | Archivelog Generation Hourly Monitoring
https://youtu.be/1qdVvbRoumY

Blog:
Automation Script | Archivelog Generation Hourly Monitoring https://mallik034.blogspot.com/2024/04/automation-script-archivelog-generation.html

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html

Automation Script | Archivelog Generation Hourly Monitoring
1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month.
2. Set the environment to a database where you are generating the archivelog generation for last 30 days
3. Hours archivelog generation monitoring script
4. Run the hour archivelog monitoring script against ORCL database


Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Automation Script | Archivelog Generation Hourly Monitoringhttps://mallik034.blogspot.com/2024/04/automation-script-archivelog-generation.htmlUpcoming Batch ...

29/09/2024

DEMO Recording!!!
Whomever missed to attend the Live Demo Sessions for RAC Course, Please do refer them here.

We have few seats are left out for this this RAC Batch, do ping me in case if you are interested to enrol for this batch 🙏

Day_1_Demo_Session | RAC Course | RAC Architecture & RAC Networking
https://youtu.be/7MuSHOwZxb4?si=uqLFXXHAe6KeB7ez

Day_2_Demo_Session | RAC Course | RAC Maintenance & RAC File System & RAC Administration
https://youtu.be/vmmUseU1r-s?si=j_0a-bX6B17_yiTo

RAC Course Curriculum link:
https://mallik034.blogspot.com/p/rac-training.html

Actual Course is Starting on:
05-Oct-2024 (Saturday) IST and Time: 08:30 AM IST to 12:30 PM IST
04-Oct-2024 (Friday) EST and Time: 11:00 PM EST to 03:00 AM EST

Weekend Batch: Saturday & Sunday only
Time: 08:30 AM IST to 12:30 PM IST (11:00 PM EST to 03:00 AM EST) (4 hour on weekends)
Duration: 5 Weekends
RAC Course fees: 15K INR (185 USD)
Mode: Online Live Classes over a zoom
Oracle Version: 19c Version

Minimum Requirement:
Basics of Windows
Basics Linux
Basics SQLs
Basics Database Knowledge
Hardware: 20GB RAM & 150GB SSD Hard disk
(Lab setup will be done using using Virtual Box)

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Demo Session - 12.RAC-Batch-28-Sep-2024:Demo Date & Time: 28-Sep-2024 & 29-Sep-2024 (Sat & Sun) IST08:30 AM IST to 10:30 AM IST27-Sep-2024 & 28-Sep-2024 (Fri...

28/09/2024

Day_1_Demo_Session | RAC Course | RAC Architecture & RAC Networking
https://www.youtube.com/watch?v=7MuSHOwZxb4

Demo Session - 12.RAC-Batch-28-Sep-2024:
Demo Date & Time:
28-Sep-2024 & 29-Sep-2024 (Sat & Sun) IST
08:30 AM IST to 10:30 AM IST

27-Sep-2024 & 28-Sep-2024 (Fri & Sat) EST
11:00 PM EST to 01:00 AM EST

Demo Zoom link:
https://us02web.zoom.us/j/81318364701?pwd=I993cqTYDqORsBwbDHAvM6fLhKUZz7.1
Meeting ID: 813 1836 4701
Security Passcode: 121212

RAC Course Curriculum link:
https://mallik034.blogspot.com/p/rac-training.html

Actual Course is Starting on:
05-Oct-2024 (Saturday) IST and Time: 08:30 AM IST to 12:30 PM IST
04-Oct-2024 (Friday) EST and Time: 11:00 PM EST to 03:00 AM EST

Weekend Batch: Saturday & Sunday only
Time: 08:30 AM IST to 12:30 PM IST (11:00 PM EST to 03:00 AM EST) (4 hour on weekends)
Duration: 5 Weekends
RAC Course fees: 15K INR (185 USD)
Mode: Online Live Classes over a zoom
Oracle Version: 19c Version

Minimum Requirement:
Basics of Windows
Basics Linux
Basics SQLs
Basics Database Knowledge
Hardware: 20GB RAM & 150GB SSD Hard disk
(Lab setup will be done using using Virtual Box)

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Demo Session - 12.RAC-Batch-28-Sep-2024:Demo Date & Time: 28-Sep-2024 & 29-Sep-2024 (Sat & Sun) IST08:30 AM IST to 10:30 AM IST27-Sep-2024 & 28-Sep-2024 (Fri...

25/09/2024

Demo Session - 12.RAC-Batch-28-Sep-2024:
Demo Date & Time:
28-Sep-2024 & 29-Sep-2024 (Sat & Sun) IST
08:30 AM IST to 10:30 AM IST

27-Sep-2024 & 28-Sep-2024 (Fri & Sat) EST
11:00 PM EST to 01:00 AM EST

Demo Zoom link:
https://us02web.zoom.us/j/81318364701?pwd=I993cqTYDqORsBwbDHAvM6fLhKUZz7.1
Meeting ID: 813 1836 4701
Security Passcode: 121212

RAC Course Curriculum link:
https://mallik034.blogspot.com/p/rac-training.html

Actual Course is Starting on:
05-Oct-2024 (Saturday) IST and Time: 08:30 AM IST to 12:30 PM IST
04-Oct-2024 (Friday) EST and Time: 11:00 PM EST to 03:00 AM EST

Weekend Batch: Saturday & Sunday only
Time: 08:30 AM IST to 12:30 PM IST (11:00 PM EST to 03:00 AM EST) (4 hour on weekends)
Duration: 5 Weekends
RAC Course fees: 15K INR (185 USD)
Mode: Online Live Classes over a zoom
Oracle Version: 19c Version

Minimum Requirement:
Basics of Windows
Basics Linux
Basics SQLs
Basics Database Knowledge
Hardware: 20GB RAM & 150GB SSD Hard disk
(Lab setup will be done using using Virtual Box)

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

21/09/2024

Please refer the recent demo session conducted for upcoming DBA course!
We had an incredible interaction with everyone, diving deep into

- Oracle DBA Course
- Course Content
- Basic Understanding of Oracle Database Architecture
- Database Connection
- Understanding of Standalone Vs RAC database
- RAC Database Advantages

A big thank you to all participants for your engaging questions and insights! Your enthusiasm made the session truly special.

Day_1_Demo_Session | Introduction About Database Course | Course Timing & Fees Structure
👇👇👇
https://youtu.be/U5ubXGQV3wM

Day_2_Demo_Session | How Database Connection Works?
👇👇👇
https://youtu.be/cfsdynzZ7uA?si=cEhBbqjY6sk5opcV

Feel free to reach out with any questions or feedback. Looking forward to continuing the conversation!

Course starting on This coming Monday 23-Sep-2024. Feel free to reach out to me on my Cell/WhatsApp/Email.

Database Course Curriculum link:
https://mallik034.blogspot.com/p/database-training.html

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html




Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

19/09/2024

Day_1_Demo_Session | Introduction About Database Course | Course Timing & Fees Structure
https://youtu.be/U5ubXGQV3wM

Demo Session - 17.DBA-Batch-19-Sep-2024:
Demo Date & Time:
19-Sep-2024 & 20-Sep-2024 (Thu & Fri) IST
8:30 AM IST to 10:30 AM IST

18-Sep-2024 & 19-Sep-2024 (Wed & Thu) EST
11:00 PM EST to 01:00 AM EST

Demo Zoom Link:
https://us02web.zoom.us/j/84675108118?pwd=ndS5QQZso8sYE32KRIkqPZc7aAnaed.1
Meeting ID: 846 7510 8118
Security Passcode: 121212

Database Course Curriculum link:
https://mallik034.blogspot.com/p/database-training.html

Actual Course is Starting on:
23-Sep-2024 (Monday) and Time: 8:30 AM IST to 10:30 AM IST
22-Sep-2024 (Sunday) and Time: 11:00 PM EST to 01:00 AM EST

Weekdays Batch: Monday to Friday
Time: 08:30 AM IST to 10:30 AM IST (11:00 PM EST to 01:00 AM EST) (2 hour everyday Mon to Fri)
Duration: 35 days
Database Course fees 10K INR (125 USD)
Mode: Online Live Classes over a zoom
Oracle Version: 19c Version

Minimum Requirement:
Anyone can attend this course
Basics of Win and Linux Knowledge
Basics of SQL
Hardware: Windows with 10GB RAM & 100GB SSD Hard disk (Lab setup will be done using using Oracle Virtual Box)

Upcoming Batch Schedule link:
https://mallik034.blogspot.com/p/upcoming-batch-schedule.html



Regards,
Mallikarjun / Vismo Technologies
WhatsApp: +91 9880616848 / +91 9036478079
Cell: +91 9880616848 / +91 9036478079
Email: [email protected] / [email protected] / [email protected]

Demo Session - 17.DBA-Batch-19-Sep-2024:Demo Date & Time: 19-Sep-2024 & 20-Sep-2024 (Thu & Fri) IST8:30 AM IST to 10:30 AM IST 18-Sep-2024 & 19-Sep-2024 (Wed...