Solved

init.ora

Posted on 2006-10-22
3
1,692 Views
Last Modified: 2012-08-13
can you please explain creation of init.ora while creation of database in oracle 10g?
0
Comment
Question by:dbaseek
3 Comments
 

Author Comment

by:dbaseek
ID: 17782959
very urgent please........
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 17783698
if you are creating a database manuall you need to create a pfile which contains the details like
 
  * .database name
  *.control file location
  *.database block size
  *.Udump,bdump ,cdump locations
  *.Sga max size
  *.Other sga parameters
  *.Archivelog path
 

 you need to specify all this when you are creating a pfile.


*. only using a init file you can bring up ur database to nomount state,when u give startup nomount pfile=path\inittest.ora  the intifile details will be fetched.
*.the after that you can create the database using database creation commands as like i given you recently
          Please Refer,
                                 http://www.experts-exchange.com/Databases/Oracle/Q_22025284.html        


 when you see 8i,9i,10g ,Some of the parameters in old versions will be made obsolute in the new version ( made default true ).
 
 Like in 10g,You can see many of the parameters avail in 9i has been made obsolute.


let me know wat you exactly looking for ??
0
 
LVL 9

Accepted Solution

by:
konektor earned 500 total points
ID: 17783934
pfile is not necessary in 10g, even in 9i.
pfile (name initSID.ora, it's text file) was used as parameter file for startup database. all necessary parameter was stored there. some of them can be modified via ALTER SYSTEM command, but after restart they will be taken from pfile. if you want to make change persistent you must chane parameter both in pfile and dynamically for database.
9i and 10g uses spfile (it's binary file). you can do changes via ALTER SYSTEM SET parameter=value SCOPE [MEMORY|SPFILE|BOTH] command. for backwadr comatibility u can also use pfile for startup and there is posibility to create pfile from spfile and vice versa using CREATE  SPFILE FROM PFILE or CREATE PFILE FROM SPFILE

see http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref441 for more details
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
EXECUTE IMMEDIATE 5 53
Oracle RAC 12c 8 56
Processing of multiple cursor 6 35
Oracle SQL syntax check  without executing 6 34
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now