Majid,
1. Create ini.ora, link this ini.ora to your oracle_home/dbs
2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
create database TESTDB
maxdatafiles 1021
maxinstances 1
maxlogfiles 8
maxlogmembers 4
character set WE8ISO8859P15
datafile
forgot couple things, add this database to your oratab and added it to
your tnsnames.ora
Joan Hsieh wrote:
Majid,
1. Create ini.ora, link this ini.ora to your oracle_home/dbs
2. startup nomount pfile=$ORACLE_HOME/dbs/initestdb.ora
create database TESTDB
maxdatafiles 1021
Title: RE: How to create a new oracle database from SVRMGRL??
If I may be so bold as to add a few details
on a UNIX server you can just fire up sqlplus (or svrmgrl for older versions of Oracle) and issue the create database statement.
On a Windows server you must first create the service
You should do it from sqldba or you should use ior init.
Don't use svrmgrl
-Original Message-
From: majid [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Subject: How to create a new oracle database from SVRMGRL??
1) Read docs on the topic
2) Yes, you can
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 10:50 AM
1)how can I create a new database frm SVRMGRL ?
2)can I have more
Mladen, you forgot:
-:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 11:13 AM
You should do it from sqldba or you should use ior init.
Don't use svrmgrl
-Original
Hi Majid,
1)how can I create a new database frm SVRMGRL ?
Use DATABASE MIGRATION ASSISTANT, it is more easy to use.
2)can I have more than one database running in
oracle8i?
Yes you can.
Hope this helps.
Rgrds,
Sony