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
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
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
'/testdb/sy
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
>
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
>
>
> > --
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 mo
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??
>