| Queries regarding manually create database in oracle 9i [message #420708] |
Tue, 01 September 2009 13:26  |
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 #420712 is a reply to message #420708] |
Tue, 01 September 2009 13:57  |
 |
Mahesh Rajendran
Messages: 10707
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  .
[Updated on: Tue, 01 September 2009 13:59] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
