deepakguptadba.blogspot.com

MY LEARNING AS AN ORACLE DBA

MY LEARNING AS AN ORACLE DBA. Thursday, August 19, 2010. Environment setup at Oracle RAC Database Server on Linux o/s (oraenv). I have a RAC database named “TEST”, with instances TEST1 and TEST2. The default entry in the oratab looks something like this:. TEST:/u01/app/oracle/product/11.2.0/dbhome 1:N. Oracle@oscqadb02 ]$ . oraenv. ORACLE SID = [QAERIE1]? TEST - - sets the *home* correctly, but does not set the instance. I have to do it manually. Here is the workaround:. To get database name:. Deepak Gup...

http://deepakguptadba.blogspot.com/

OVERVIEW OF deepakguptadba.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR DEEPAKGUPTADBA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

March

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.3 out of 5 with 12 reviews

5 star

7

4 star

4

3 star

0

2 star

0

1 star

1

Hey there! Start your review of deepakguptadba.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

3.8 seconds

CONTACTS AT DEEPAKGUPTADBA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

3.763 sec

SCORE

6.2

PAGE TITLE

MY LEARNING AS AN ORACLE DBA | deepakguptadba.blogspot.com Reviews

<META> DESCRIPTION

MY LEARNING AS AN ORACLE DBA. Thursday, August 19, 2010. Environment setup at Oracle RAC Database Server on Linux o/s (oraenv). I have a RAC database named “TEST”, with instances TEST1 and TEST2. The default entry in the oratab looks something like this:. TEST:/u01/app/oracle/product/11.2.0/dbhome 1:N. Oracle@oscqadb02 ]$ . oraenv. ORACLE SID = [QAERIE1]? TEST - - sets the *home* correctly, but does not set the instance. I have to do it manually. Here is the workaround:. To get database name:. Deepak Gup...

<META> KEYWORDS

1 export oracle sid=test1

2 login as root

3 for example

4 len=`hostname

5 wc c`

6 nodenum=`hostname

7 cut c$len1 $len`

8 test

9 oracle@oscqadb02 $ sid

10 oracle@oscqadb02

CONTENT

Page content here

KEYWORDS ON PAGE

export oracle sid=test1,login as root,for example,len=`hostname,wc c`,nodenum=`hostname,cut c$len1 $len`,test,oracle@oscqadb02 $ sid,oracle@oscqadb02,posted by,1 comment,email this,blogthis,share to twitter,share to facebook,share to pinterest,sql startup

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

MY LEARNING AS AN ORACLE DBA | deepakguptadba.blogspot.com Reviews

https://deepakguptadba.blogspot.com

MY LEARNING AS AN ORACLE DBA. Thursday, August 19, 2010. Environment setup at Oracle RAC Database Server on Linux o/s (oraenv). I have a RAC database named “TEST”, with instances TEST1 and TEST2. The default entry in the oratab looks something like this:. TEST:/u01/app/oracle/product/11.2.0/dbhome 1:N. Oracle@oscqadb02 ]$ . oraenv. ORACLE SID = [QAERIE1]? TEST - - sets the *home* correctly, but does not set the instance. I have to do it manually. Here is the workaround:. To get database name:. Deepak Gup...

INTERNAL PAGES

deepakguptadba.blogspot.com

1

MY LEARNING AS AN ORACLE DBA: April 2010

http://deepakguptadba.blogspot.com/2010_04_01_archive.html

MY LEARNING AS AN ORACLE DBA. Sunday, April 25, 2010. Precautions before a shutdown a database. Before a shutdown the Production or any important database, take some basic precaution besides the backup. Create an init parameter file from current spfile (If database is using spfile). In case, If database is not mounting / coming up or need to disable some of parameter(s) or database feature to startup :. SQL create pfile from spfile;. Create backup of a control file in text format. Xxx1 ora 30518.trc.

2

MY LEARNING AS AN ORACLE DBA: Manually upgrade the Database 10g2 (10.2.0.4) to Oracle database 11g2 on Redhat Linux 5

http://deepakguptadba.blogspot.com/2010/08/manually-upgrade-database-10g2-10204-to.html

MY LEARNING AS AN ORACLE DBA. Sunday, August 8, 2010. Manually upgrade the Database 10g2 (10.2.0.4) to Oracle database 11g2 on Redhat Linux 5. 1 Run utlrp.sql to recompile any remaining stored PL/SQL and Java code. 2 Check dba registry. Column comp name format a40. Select trim(comp name) comp name , version , status from dba registry;. 3 Verify that all expected packages and classes are valid:. SQL select count(*) from dba objects where status ’VALID’. 4 Backup the database. 6 Shut down the instance:.

3

MY LEARNING AS AN ORACLE DBA: July 2010

http://deepakguptadba.blogspot.com/2010_07_01_archive.html

MY LEARNING AS AN ORACLE DBA. Wednesday, July 28, 2010. Recovering a Standby database from a missing archives log. Recover Gaps in Standby Database from primary Using incremental backups. Step 1: On the standby database find out the current SCN. Standby select current scn from v$database;. Step 2: On the primary database, create an incremental backup from the above SCN. Step 3: Cancel managed recovery at the standby database. STDBY alter database recover managed standby database cancel;. DBID 23623369570...

4

MY LEARNING AS AN ORACLE DBA: Managing Archive Gaps Manually on Standby Database Setup

http://deepakguptadba.blogspot.com/2010/04/managing-archive-gaps-manually-on.html

MY LEARNING AS AN ORACLE DBA. Saturday, April 24, 2010. Managing Archive Gaps Manually on Standby Database Setup. To determine if there is an archive gap on your physical standby database. SQL SELECT * FROM V$ARCHIVE GAP;. THREAD# LOW SEQUENCE# HIGH SEQUENCE#. In this case, Standby database is waiting for archive log 12499. SQL select process,sequence#,status from v$managed standby;. MRP0 12499 WAIT FOR GAP. Oracle@xxxdb2 ]$ cd /oracle/backups/xxx2/stby archive. Oracle@xxxdb2 stby archive]$ ll -l 1 12499*.

5

MY LEARNING AS AN ORACLE DBA: December 2009

http://deepakguptadba.blogspot.com/2009_12_01_archive.html

MY LEARNING AS AN ORACLE DBA. Monday, December 28, 2009. Oracle database's fixed date feature usage script. Some time, there is requirement to advance the database’s date to test month end or advance date related batch process. One way to change the date at O/s level but it may difficult if there are more than databases in Database Server box. Below script is used fixed date feature to set advance date and increments / synchronies the time after every 2 minutes through script. Cat instance list node2.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

deepakgupta.net

DEEPAK GUPTA's Personal Website

BTech, IIT Guwahati. Experis IT Pvt Ltd. A competent professional with nearly 10 years of IT experience in various projects doing Analysis, Design, Development, Deployment, Maintenance and Production Support in CAD, Investment Banking and E-Commerce Domain Applications. Around 8 Years of experience in developing applications using Microsoft Technologies and 2 Years of experience in developing applications using C language. Capabilities in leading large-scale business application architecture and design e...

deepakgupta.org

deepak gupta

Notes, pictures and thoughts from this simulation called life. Yash Pal Gupta (6th Nov 1952 - 5th Nov 2017). May your soul travel in peace, daddy. Your presence will always be missed. Sunday, 12 November 2017. Ldquo;Home is people. Not a place. If you go back there after the people are gone, then all you can see is what is not there any more.” ― Robin Hobb, Fool’s Fate. Clicked on 16th April 2016 at Ramnagar, Jammu and Kashmir, India. Monday, 27 June 2016. Mdash; Deepak Gupta (@deepakgupta1). The best wa...

deepakgupta.wordpress.com

It\'s my Life | My Daily Highs and Lows, Successes and Failures, Triumphs and Defeats, Hits and Misses and just about everything else

It ’s my Life. My Daily Highs and Lows, Successes and Failures, Triumphs and Defeats, Hits and Misses and just about everything else. May 3, 2006. Joke – Bush vs. Gurmukh. Posted in Highs and Lows. At 9:59 am by Sinister. Hi, this is a really good one. Enjoy. George Bush was sitting in his office wondering whom to invade next when his telephone rang. Hallo, Mr. Bush! A heavily accented voice said, This is Gurmukh from Phagwara, District Kapurthala,. How big is your army. Oh teri …. said Gurmukh...Mr Bush...

deepakguptaclasses.blogspot.com

Deepak Gupta Classes

Saturday, August 15, 2009. Private Accounting and Taxation Courses. This topic is under construction. TRP Scheme - Low Cost Return Filing for Common Man. Proposed Goods and Services Tax. New Proposed Direct Tax Code. This topic is under construction. Subscribe to: Posts (Atom). Private Accounting and Taxation Courses. TRP Scheme - Low Cost Return Filing for Common Man. Proposed Goods and Services Tax. New Proposed Direct Tax Code. View my complete profile.

deepakguptaclasses.com

Deepak Gupta Classes

Spreading Branches of Responsible and Quality Education. CS, CA-IPCC, ICWA, MBA, M.COM, B.COM, BBA, XII, XI. Welcome to the Online Home of Deepak Gupta Classes. We are a pioneer name in commerce and finance education in Delhi Circles. We are providing responsible and quality education with a difference since 1994. We are the only cost effective institute where admissions once taken will be applicable till the final examinations. Deepak Gupta Classes - "The Education You Desire". Develop discipline and th...

deepakguptadba.blogspot.com

MY LEARNING AS AN ORACLE DBA

MY LEARNING AS AN ORACLE DBA. Thursday, August 19, 2010. Environment setup at Oracle RAC Database Server on Linux o/s (oraenv). I have a RAC database named “TEST”, with instances TEST1 and TEST2. The default entry in the oratab looks something like this:. TEST:/u01/app/oracle/product/11.2.0/dbhome 1:N. Oracle@oscqadb02 ]$ . oraenv. ORACLE SID = [QAERIE1]? TEST - - sets the *home* correctly, but does not set the instance. I have to do it manually. Here is the workaround:. To get database name:. Deepak Gup...

deepakguptadba.wordpress.com

My Learning as Oracle DBA | Let share the knowledge.

My Learning as Oracle DBA. Let share the knowledge. To reset existing (Oracle) Sequence. August 31, 2011. Set the value of variable cnt fx to reset the Oracle Sequence. Replace owner and SEQUENCE name with your schema owner and Sequence name. Login to Database and execute below SQLs:. 8212; Target sequence number#. 8212; change the number that you want reset or set. Cnt fx integer := 701. Cnt final integer;. Select owner.SEQUENCE name.nextval into cnt from dual;. Cnt final := cnt fx – cnt;. May 9, 2011.

deepakguptarealty.com

Central Florida Orlando Real Estate Homes For Sale

deepakguptaseo.blogspot.com

Deepak Gupta Google SEO, Anylatics & World Wide Web News Search

Deepak Gupta Google SEO, Anylatics and World Wide Web News Search. Deepak Gupta - SEO Offer Social Media Tips and Updates webmaster and Analytics update and all over news @deepakguptaseo@blogspot.in. Saturday, October 22, 2016. गूगल की कुछ Popular Services. Google Talk, Hangout. Google Earth / Map. Webmaster Tools and Google Analytic. Posted by Deepak Gupta. Subscribe to: Posts (Atom). Simple theme. Theme images by luoman.

deepakgururaja.wordpress.com

Deepak Gururaja | Lead by Examples, Teach by activities

Lead by Examples, Teach by activities. An Agile coach with a passion for Agile way of life. About 7 years into my professional life, and I was given a challenge. I was offered the role of a Scrum Master. All my prior experience was either as an individual team member, or, purely as a people manager. This was something new, and different. Instead of calling out that I had an impediment, I had to, now, collect and resolve impediments. At one point, it dawned on me that giving. Leave a Reply Cancel reply.

deepakgyawali.com.np

|| DEEPAK GYAWALI || deepakgyawali.com.np

Software Engineer, Programmer and Web Designer. I'm a freelance web designer. Worked with medium and big organizations. You need quality and i’m your man. I specialize in custom based CMS, and web page design and development, also have worked on many different platforms and am continually expanding my reach. I have worked with businesses and individuals of varying sizes to set up great web solutions. I've also gained education and experience in illustration and motion design. Clubholidays Travel and Tours.