Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How do you switch from an init.ora file to a spfile?

Question Posted / ramakrishnach.dba

Answer Posted / ramakrishnach.dba

oracle searches parameter file in following manner

1) spfile$ORACLE_SID.ora
2) spfile.ora
3) init$ORACLE_SID.ora
4) init.ora

if oracle finds spfile$ORACLE_SID.ora file it ignores rest of the files

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you find out if a table can be redefined?

1004

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2025

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2098

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2266

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

983

What is dbcc? : sql server DBA

1280

how can you connect from 10g user to 11g user??

2105

What is replication? : sql server DBA

1165

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2494

what functionality does oracle provide to secure sensitive information?

985

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2441

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

985

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2674

What is a correlated sub-query? : sql server DBA

1075

How do you open a cluster administrator? : sql server DBA

1091