gauthamc.blogspot.com

Random Oracle Posts

Tuesday, January 7, 2014. Convert Single Instance Database to Oracle RAC One Node Database / RAC 1 node database. I had the recent need to convert a single instance DB to a RAC 1-node. I haven't seen many documents. Which talks about the steps involved As most docs focus on conversion from single instance to a regular RAC. I drove into the scripts and to my best abilities, tried to reproduce what it does and have written the below blog. Before you start, ensure. Db create file dest=" DATA DEV". With the ...

http://gauthamc.blogspot.com/

OVERVIEW OF gauthamc.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 GAUTHAMC.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.2 out of 5 with 18 reviews

5 star

9

4 star

6

3 star

2

2 star

0

1 star

1

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.4 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT GAUTHAMC.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

216.58.194.161

LOAD TIME

0.407 sec

SCORE

6.2

PAGE TITLE

Random Oracle Posts | gauthamc.blogspot.com Reviews

<META> DESCRIPTION

Tuesday, January 7, 2014. Convert Single Instance Database to Oracle RAC One Node Database / RAC 1 node database. I had the recent need to convert a single instance DB to a RAC 1-node. I haven't seen many documents. Which talks about the steps involved As most docs focus on conversion from single instance to a regular RAC. I drove into the scripts and to my best abilities, tried to reproduce what it does and have written the below blog. Before you start, ensure. Db create file dest= DATA DEV. With the ...

<META> KEYWORDS

1 random oracle posts

2 remote login passwordfile=exclusive

3 5 disable the database

4 startup

5 scope=spfile;

6 scope=spfile ;

7 posted by

8 gautha

9 no comments

10 email this

CONTENT

Page content here

KEYWORDS ON PAGE

random oracle posts,remote login passwordfile=exclusive,5 disable the database,startup,scope=spfile;,scope=spfile ;,posted by,gautha,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,bin/bash,exit 1,stored line ctr=0

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Random Oracle Posts | gauthamc.blogspot.com Reviews

https://gauthamc.blogspot.com

Tuesday, January 7, 2014. Convert Single Instance Database to Oracle RAC One Node Database / RAC 1 node database. I had the recent need to convert a single instance DB to a RAC 1-node. I haven't seen many documents. Which talks about the steps involved As most docs focus on conversion from single instance to a regular RAC. I drove into the scripts and to my best abilities, tried to reproduce what it does and have written the below blog. Before you start, ensure. Db create file dest=" DATA DEV". With the ...

INTERNAL PAGES

gauthamc.blogspot.com

1

Random Oracle Posts: March 2013

http://gauthamc.blogspot.com/2013_03_01_archive.html

Monday, March 4, 2013. Restore and recover from cold backup using rman. Many a times before a application upgrade, we would like to take a cold backup of the database just to take care of some "mess-up" and would just want to restore it if something goes wrong. The following is the preferred way for me to take a RMAN cold backup. Put the DB in mount mode. Rman target / nocatalog EOF backup.log. Allocate channel d1 device type disk format '/oracle/arch/rmanbkp/HOMEDB FULL %d %T %U';. List of Backup Sets.

2

Random Oracle Posts: November 2011

http://gauthamc.blogspot.com/2011_11_01_archive.html

Wednesday, November 16, 2011. Change refresh schedules for an Oracle Materialized View ( MV ). Here is an automated script to change the refresh schedule for all MV's for a particular schema(in our case the. Schema name is GGAMADM). Please run this as DBA user (or change dba mviews to user mviews). The basic syntax is. ALTER MATERIALIZED VIEW abc. START WITH trunc(sysdate 1) (10/24). The above command refreshes the MV at 10am and 2pm. Is select mview name from dba mviews where owner='GGAMDADM';.

3

Random Oracle Posts: December 2012

http://gauthamc.blogspot.com/2012_12_01_archive.html

Tuesday, December 11, 2012. Let me give you a typical scenario which we encounter everday. Say we have a table called employee and the fields are (or rather the most significant fields for our discussion) are. Ename and dno . SQL select substr(ename,1,25),dno from employee;. SUBSTR(ENAME,1,25) DNO. You are being asked to write a small pl/sql code to return the enames of a particular department, the normal way we would. Do is to write a procedure like. Ename p := vcarray();. For c2 in c1. 2 ename vcarray ;.

4

Random Oracle Posts: Extraction of Grants from a schema

http://gauthamc.blogspot.com/2013/11/extraction-of-grants-from-schema.html

Thursday, November 7, 2013. Extraction of Grants from a schema. The following should be able to extract all the grants given from a particular schema to the other schemas. This is particular useful when you have a bunch of schemas (with cross grants) and you are planning to move schema by schema and then finally apply the grants when all schemas are moved over. Expdp '/ as sysdba ' schemas=scott dumpfile=scott role.dmp nologfile=yes include=owner grant. Subscribe to: Post Comments (Atom).

5

Random Oracle Posts: November 2013

http://gauthamc.blogspot.com/2013_11_01_archive.html

Thursday, November 7, 2013. Extraction of Grants from a schema. The following should be able to extract all the grants given from a particular schema to the other schemas. This is particular useful when you have a bunch of schemas (with cross grants) and you are planning to move schema by schema and then finally apply the grants when all schemas are moved over. Expdp '/ as sysdba ' schemas=scott dumpfile=scott role.dmp nologfile=yes include=owner grant. Here are the challenges :. ALERT LOG FILE=/u01/app/...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

gauthaman.com

Contiguous Design

This competition entry, which was shortlisted to the final 10 entrants, was to provide a new Visitors centre for the. The Client, Bolton Berhad, are a Property Developer who required a flexible Show Gallery on the ground floor of a. This private residence, located in Kuala Lumpur, is currently on schedule and due for completion in September 2013.The Client stated. This competition entry was for a development in the nearby city of Cyberjaya was shortlisted and is currently awaiting the.

gauthamanpoems.blogspot.com

gauthaman poems

Wednesday, November 24, 2010. There was a boy called. He was poor. He had his wife , his house and a cow . one day his wife said let’s sell the cow in a city .so he went. To a city. He met a man and he asked are you deciding to sell the cow? Aravind said yes. He said to aravind are you mad! My dear friend want a choclate milk shake free . joseph said I am coming and after the joseph drank the shake he went to the billing he took his cap and threw it and caught it and said have I paid the bill. Chennai su...

gauthamarts.com

Gautham Arts - Candles, Essential Oils, Diffusers, Candle Stands, Glass, Trophies, Buffet Items, Radium Articles, Ga Speciality, Gift Hampers

Water Soluble Essential Oil. Fruits Veg and Sweets. Lucky Animals and Vastu. We, Gautham Arts present you with a wide variety of premium handicraft products, ranging from aromatic candles to glassware. The candles are made using a unique A grade formula wax and specially sourced German wicks, making them smokeless with longer burning hours. They come in various sizes (1inch to 3.5 ft ),shapes, perfumes and colors, weighing from 10 gms up to 20 kilos. Water Soluble Essential Oil.

gauthamazki.deviantart.com

Gauthamazki (Gautham) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 8 Years. This deviant's full pageview. Last Visit: 94 weeks ago. This is the place where you can personalize your profile! Thank yo...

gauthambuddha.com

The domain gauthambuddha.com is for sale. To purchase, call Afternic at 1 339-222-5147 or 866-836-6791. Click here for more details.

gauthamc.blogspot.com

Random Oracle Posts

Tuesday, January 7, 2014. Convert Single Instance Database to Oracle RAC One Node Database / RAC 1 node database. I had the recent need to convert a single instance DB to a RAC 1-node. I haven't seen many documents. Which talks about the steps involved As most docs focus on conversion from single instance to a regular RAC. I drove into the scripts and to my best abilities, tried to reproduce what it does and have written the below blog. Before you start, ensure. Db create file dest=" DATA DEV". With the ...

gauthamceramics.com

Gautham Ceramics

Sub Item 3.1a. Sub Item 3.2a. Sub Item 3.3a. Sub Item 3.4a. Sub Item 5.1a. Item Folder 5.2a. Sub Item 5.2.1a. Sub Item 5.2.2a. Sub Item 5.2.3a. Sub Item 5.2.4a. Sub Item 3.1b. Sub Item 3.2b. Sub Item 3.3b. Sub Item 3.4b. Sub Item 5.1b. Item Folder 5.2b. Sub Item 5.2.1b. Sub Item 5.2.2b. Sub Item 5.2.3b.

gauthamchandra.com

Gautham Chandra | Frontend Developer

Front-end Developer in New York.

gauthamchelsealegend.blogspot.com

Gautham.A.S'Official Blog

Gautham.A.S'Official Blog. Read on without wory, 2012 will not happen! Wednesday, July 6, 2011. Sunday, February 20, 2011. Wonder La Amusement Park Trip Bangalore. Wonder La is the best amusement park in all of India and the Indian sub-continent and we Bangaloreans are lucky to have it near Bangalore. Wonder La is just 30 kilometers away from Bangalore and can be reached by taking 226 bus series from Majestic Bus stand. The fees range from 400 to 600 depending on the day of the week you are visiting.

gauthamcollege.blogspot.com

Gautham College of Pharmacy

Gautham College of Pharmacy. Wednesday, February 16, 2011. Welcome to Gautham College of Pharmacy Blogspot. The profession of pharmacy is noble in its ideal and character. Pharmaceutical services are becoming valuable day by day to the society and assumed of greater importance. The profession of pharmacy is reaching new heights and surely a person can built a bright future with pharmacy qualification. The blog contains recent information about jobs, events, important notice etc. Subscribe to: Posts (Atom).

gauthamcollege.org

Welcome to Gautham College of Pharmacy

Welcome to Gautham College. The Gautham College of Pharmacy formally commenced its courses in 1985. The Institute has covered a long journey of 30 years starting from Mahalaxmi Layout in 1985 and finally settling to the present picturesque campus in Sultanpalya, Bangalore. Welcome to Gautham College. The profession of pharmacy is noble in its ideal and character. Pharmaceutical services are becoming valuable day by day to the society and assumed of greater importance. Gautham College of Pharmacy. Keeping...