| database creation(dbca is not working in winxp) [message #149294] |
Thu, 01 December 2005 01:32  |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
Hi all,
what my problem is
I freshly installed oracle 9.0.1.0.1 in winxp machine..
only i installed oracle software..i did not create database..
now i want to create fresh database manually...
how can i create database manually in winxp?
i wanted to do it through the DBCA utility..but it is not working..dbca is not working...can anybody please tell me how to create database manually through command mode?
if any link is there can u please give me that weblink?
Thanks in advance
subbu
|
|
|
|
| Re: database creation(dbca is not working in winxp) [message #149302 is a reply to message #149294] |
Thu, 01 December 2005 02:17  |
lazycat
Messages: 57
Registered: November 2005
|
Member |
|
|
Step 1: Decide on Your Instance Identifier (SID)
Step 2: Establish the Database Administrator Authentication Method
Step 3: Create the Initialization Parameter File
Step 4: Connect to the Instance
Step 5: Create a Server Parameter File (Recommended)
Step 6: Start the Instance
Step 7: Issue the CREATE DATABASE Statement
Step 8: Create Additional Tablespaces
Step 9: Run Scripts to Build Data Dictionary Views
Step 10: Run Scripts to Install Additional Options (Optional)
Step 11: Back Up the Database.
|
|
|
|
| Re: database creation(dbca is not working in winxp) [message #149303 is a reply to message #149294] |
Thu, 01 December 2005 02:19 |
lazycat
Messages: 57
Registered: November 2005
|
Member |
|
|
linux
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 ('/u01/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
|
|
|
|
| Re: database creation(dbca is not working in winxp) [message #149304 is a reply to message #149303] |
Thu, 01 December 2005 02:22 |
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
|
Member |
|
|
hi
thanks for reply..
ya i have done successfully on linux..
when it is coming to windowsxp ..it is the problem.
can u tell me any link is there..
how to create database in winxp through the command mode step by step?...just i installed the software only ...i did not create the database..
thanks in advance
subbu
[Updated on: Thu, 01 December 2005 02:25] Report message to a moderator |
|
|
|
| Re: database creation(dbca is not working in winxp) [message #149306 is a reply to message #149294] |
Thu, 01 December 2005 02:29 |
lazycat
Messages: 57
Registered: November 2005
|
Member |
|
|
CREATE DATABASE prod
MAXLOGFILES 5
MAXDATAFILES 100
DATAFILE 'oracle\oradata\prod\system01.dbf' SIZE 325M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS" DATAFILE 'oracle\oradata\prod\undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
logfile 'C:\oracle\oradata\prod\redo01.log' size 100M reuse,
'C:\oracle\oradata\prod\redo02.log' size 100M reuse,
'C:\oracle\oradata\prod\redo03.log' size 100M reuse;
it is more difficut create it on window than linux
you can see it in
Oracle9i Database Administrator's Guide
Release 2 (9.2) for Windows
Part Number A95491-01
good luck
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
