×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

creating a new database in newly installed oracle on adifferent drive

creating a new database in newly installed oracle on adifferent drive

creating a new database in newly installed oracle on adifferent drive

(OP)
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

RE: creating a new database in newly installed oracle on adifferent drive

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.

RE: creating a new database in newly installed oracle on adifferent drive

(OP)
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 c:\
(refer 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

RE: creating a new database in newly installed oracle on adifferent drive

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!

RE: creating a new database in newly installed oracle on adifferent drive

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close