My Experiments with Oracle & Others- By $riram $anka

All About Issues, Errors,News & Latest Findings etc

  • Moderator at

  • Member at

  • Categories

  • Archives

  • January 2020
    M T W T F S S
    « Jun    
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  
  • Blogs I Follow

Archive for the ‘Oracle Administration’ Category

Quick Steps to Install Oracle 19c in Windows

Posted by Sriram Sanka on June 14, 2019


 

Step 1 : Download Oracle 19c DB software for Windows using https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Step 2 : Unzip using 7-Zip to your Destination folder.

Step 3 : Navigate to the Extracted Home Folder and Click on Setup.Exe.   

 

These 3 Simple Steps will launch “OUI” for Installing 19c , go-ahead and  proceed with the Interactive ” Next ” Options.

Happy Reading !

Posted in Installation, Oracle Administration, Oracle Server Administration, Windows | Leave a Comment »

Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”

Posted by Sriram Sanka on February 23, 2018


There is a known issue with clonedb.pl script,  you might end-up with “Missing braces on \o{} at clonedb.pl line 245, near “$lne’ , ‘$clonedbdir”  Especially if you are using perl Vv5.10.1.

 Actual Line: print OUTFILE1 “dbms_dnfs.clonedb_renamefile(‘$lne’,’$clonedbdir/\ora_data_$cldbname$i.dbf’); \n”; 

You will get the Error when this Line of code  executed and “\o” is the root cause in Perl Execution. 

 

to avoid this, just define a new Variable $var, for Ex,  in my case,  $var = “ora_data”; and place it in the Script to get the Job Done. 

‘$clonedbdir/\ora_data_$cldbname$i.dbf’); to ‘$clonedbdir/$var\_$cldbname$i.dbf’);

Make changes in the Script as needed.

 

 

Thank you for giving your valuable time to read the above information. Happy Coding !. 😉

 

Posted in Oracle Administration | Leave a Comment »

 
Oracle Diagnostician

Performance troubleshooting as exact science

deveshdba

get sum oracle stuffs

Data Warehousing with Oracle

Dani Schnider's Blog

ORASteps

Oracle DBA's Daily Work

DBAspaceblog.com

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

DBAtricksWorld.com

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBA's become bulletproof!

%d bloggers like this: