Re: How to create a new oracle database from SVRMGRL??
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/system01.dbf' size 400M logfile '/redo1/testdb/log01.dbf' size 20M, '/redo1/testdb/log02.dbf' size 20M, '/redo1/testdb/log03.dbf' size 20M; 3. run @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql 4. Create rollback tablespace 5. Create your rollback segment 6. Create all your tablespaces 7. enjoy Joan majid wrote: 1)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to create a new oracle database from SVRMGRL??
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 maxinstances 1 maxlogfiles 8 maxlogmembers 4 character set WE8ISO8859P15 datafile '/testdb/system01.dbf' size 400M logfile '/redo1/testdb/log01.dbf' size 20M, '/redo1/testdb/log02.dbf' size 20M, '/redo1/testdb/log03.dbf' size 20M; 3. run @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql 4. Create rollback tablespace 5. Create your rollback segment 6. Create all your tablespaces 7. enjoy Joan majid wrote: 1)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to create a new oracle database from SVRMGRL??
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 with oradim. For example: %ORACLE_HOME%\bin\oradim -NEW -SID %ORACLE_SID% -startmode m -pfile D:\Oradmin\%ORACLE_SID%\pfile\init%ORACLE_SID%.ora -intpwd my_secret_password -maxusers 4 -startmode m means startmode manual - the instance must be manually started after system reboot. -intpwd is the password for the sys user -maxusers 4 is the maximum number of users that can be given SYSDBA capability Once you've created the database and all the tablespaces, you may want to do the following to avoid annoying warnings everytime you startup SQL*Plus: create PRODUCT_PROFILE with this script $ORACLE_HOME/sqplus/admin/pupbld.sql (I usually create it in the SYSTEM schema) Create Plus_Trace role $ORACLE_HOME/sqplus/admin/plustrce.sql To install SQL*Plus help, look for a file called %ORACLE_HOME%\bin\helpins.bat on windows $ORACLE_HOME/bin/helpins on UNIX Finally, don't forget to change the passwords for SYS, SYSTEM, and other users automatically created by the database creation scripts. And change the TEMPORARY tablespace for users to something other than SYSTEM.
RE: How to create a new oracle database from SVRMGRL??
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)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 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 than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to create a new oracle database from SVRMGRL??
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 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)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to create a new oracle database from SVRMGRL??
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 -Original Message- From: majid [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:50 PM To: Multiple recipients of list ORACLE-L Subject: How to create a new oracle database from SVRMGRL?? 1)how can I create a new database frm SVRMGRL ? 2)can I have more than one database running in oracle8i? thanks --- [EMAIL PROTECTED] wrote: You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to create a new oracle database ????
You can use DBCA(Database Config Assistant) to create a new Oracle DB or issue the commands starting from Create database . from SVRMGRL. majid [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/03 08:43 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to create a new oracle database Hi, I am new to oracle, I just installed oracle8i in windows2000, durring the installation I called the default database test, I wrote a small java class using the JDBC, everything is working fine, my question please : 1)can I create another database in oracle (leave the database test)so I will have two databases in oracle ? 2)How can I create a database ? Thanks, your help is appreciated. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: majid INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).