creating a new database in newly installed oracle on adifferent drive

[amolso]

I have installed oracle8i on D drive of my computer
I have default database on that drive which is
automatically created on drive

Now I want to create new databas on another drive;

I have tried using database configuration assistant with accordingly changing the settings but it gave error
'database not found'

I tried it using 'internal' user from the sql prompt
but it gave me error databse already mounted.

I am in need of this help badly can u help me

amol
amolsonaikar@yahoo.com [sig][/sig]

 

[DBAwhosaysNIE]

Do you want to mount the new database using existing instance (OracleServiceORCL) or do you want a new instance (separate services) for it? I don't use gui tools (even on NT) except instance manager (alternative is regedit) but I suspect your problem lies there. If server manager gave you the already mounted error it's because you're trying to create a database using an instance which has already mounted an existing database. If you want to create a new database to use with the existing instance you'll need to do a shutdown/startup mount before creating the new one and modify instance's init.ora file to point to new control file. If you want to create a new instance you'll have to use instance manager (or regedit if you're confortable w/it) to create services for it, startup mount and create DB.

Not to be mean but if you're not familiar with basic Oracle architecture I strongly reccomend you read up on it before attempting any of this. [sig][/sig]

 

[amolso]

thank you DBAwhosaysNIE

I am basically a programmer not aware of the dba actitvities
much.
--I suppose I have to say shutdown or shudown immediate
after saying 'sqlplus' & 'connect /as sysdba' from the crefer to book Oracle8i DBA Bible)
and as i am a user of windows nt server and i do not have any dba.
--If i shutdown the database after connecting from C:will it come out of SQL to C: or will it remain on sql.
Book says you have to say startup from sql prompt
--But will it start new instance or return existing instance
or do I have to change SID ?
--I don't know how to change init.ora because it currently
gives details of existing database which i need constantly.
--creating new database from Configuration assistant asks me address of new init.ora file which it will create for new database
--after startup from 'sql' prompt DO I need to connect
as sysdba and then issue command 'CREATE DATABASE' with it's
syntax and settings or anything else i have to do ?
--I will be very glad if you can guide me by steps and
also refer me any other good book on Oracle8i DBA.
Is Oracle Press DBA guide useful in this regard.

Amol [sig][/sig]

 

[DBAwhosaysNIE]

1st a disclaimer: it's been a while (June) since I've done Oracle on NT (just Sun now) so I'm telling you this from memory.

unless something's changed I'm not aware of you can't startup/shutdown an instance with SQL*Plus; you have to use server manager (svrmgr80.exe for 8.0.x; not sure for 8i). Connect as an account with sysdba privileges (don't think you can use internal on NT) and issue a shutdown immediate (do NOT just stop the services in NT; same as shutdown abort). After the instance shuts down you will need to modify initORCL.ora (make a backup copy first) and modify as neded, particularly the control file name(s) which should have the name(s) of controlfile(s) for new database (don't worry that they don't exist yet) and the database name (should reflect new DB to be created). Issue a startup nomount (I noticed I said mount above; sorry for typo). This tells Oracle to start an instance but not to mount a controlfile(/database). At this point you can issue the create database command which I'm pretty sure will automatically mount and open it when finished (if not issue alter database open). At that point you will need to exit server manager, go in to SQL*Plus and run catalog.sql and catproc.sql.

As far as books the HTML documentation that comes with the software is pretty good with good hyperlinks. DBA Handbook is fair but for $40 I haven't seen anything in it that's not in the HTML. I do use the Oracle Press PL/SQL Programming book quite a bit but it doesn't really cover architecture or DBA tasks.

Hope that helps! [sig][/sig]

 

[amolso]

Thank you

for replying immediate. I'll try using shutdown. However
there is no file in system named initORCL.ora. If I have
to modify any file do you mean i have to take a backup
of init.ora file?
If possible let me know where I can find help on DBA admin.
(I haven't got the help on this regard on oracle corpn's
web site also. If you know any web sites which will guide
on this issue let me know)

amol [sig][/sig]