Home » RDBMS Server » Server Administration » Queries regarding manually create database in oracle 9i
Queries regarding manually create database in oracle 9i [message #420708] Tue, 01 September 2009 13:26 Go to next message
sachinkkhot
Messages: 8
Registered: January 2009
Junior Member


Create database manually with following steps:
1) Create SID
C:\> set ORACLE_SID=mynewdb

2)Create suitable database directories within oracle directory.
Create folders udump,cdump,bdump within C:\oracle\admin\mynewdb\

3)Create PFILE

4)Create a password file using:
C:\> orapwd file=C:\oracle\ora90\database\PWDmynewdb.ora password=oracle

5)Create an instance of database
C:\> oradim -new -sid mynewdb

6)Start sqlplus:
C:\> sqlplus\nolog

7)connect / as sysdba

8)startup nomount

9)Run CREATE DATABASE script

-----------------------------------------------------------------
On my pc there is "orcl" database i.e. created at when install oracle. Following are queries related to database creation:

1) In 7th step, When I run "connect / as sysdba", in this which database instance connect? although I am not create database.

2) In 8th step "startup nomount". In this, which database started in nomount?

3) What will role of PFILE in creating of database?

4) When I create password file, how I link it with new database?

Please help to solve these queries.

Thanks and Regards,
Sachin

Re: Queries regarding manually create database in oracle 9i [message #420709 is a reply to message #420708] Tue, 01 September 2009 13:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
1) In 7th step, When I run "connect / as sysdba", in this which database instance connect? although I am not create database.

The one given by ORACLE_SID.
YOu don't connect to a database but to an instance which does not need to have a database.

Quote:
2) In 8th step "startup nomount". In this, which database started in nomount?

Same answer.

Quote:
3) What will role of PFILE in creating of database?

To give
1/ parameters of the instance
2/ some structural parameters of the database like name and block size

Quote:
4) When I create password file, how I link it with new database?

You connect it to the instance by the name of the password file.

Regards
Michel
Re: Queries regarding manually create database in oracle 9i [message #420712 is a reply to message #420708] Tue, 01 September 2009 13:57 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1)
To an idle instance.
Something like this
oracle@kanada#sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 1 14:45:12 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

In simple terms, a no-specific-unstarted and expected-to-be-started instance. The instance to be started will be identified by
ORACLE_SID and PFILE.

>>2) In 8th step "startup nomount". In this, which database started in nomount?
The instance identified by ORACLE_SID. This "startup" looks for
pfile or spfile in its default location and starts the instance without mounting the database.
Alternatively, you can provide the path_to_PFILE.

>>3) What will role of PFILE in creating of database?
Read all above.
Additionally, it will identify control_files, certain vital directories, your SGA/Memory settings.

>>4) When I create password file, how I link it with new database?
Quote:

C:\> set ORACLE_SID=mynewdb
C:\> orapwd file=C:\oracle\ora90\database\PWDmynewdb.ora password=oracle


Your ORACLE_SID


Please use CODE to format the code.
All above are available in documents. Look into server concepts guide and admin guide.


Edit:

Michel was faster Smile.

[Updated on: Tue, 01 September 2009 13:59]

Report message to a moderator

Previous Topic: Error: ORA-01092: ORACLE instance terminated. Disconnection forced
Next Topic: error ora-12546 TNS permission denied(3 merged)
Goto Forum:
  


Current Time: Mon Dec 05 21:21:50 CST 2016

Total time taken to generate the page: 0.09444 seconds