Re: How can I create and delete instance and database?

ashesh48_at_my-dejanews.com wrote in message <6ofmo9$4nb$1_at_nnrp1.dejanews.com>...
>Hi,
> Thank you for your help.
> I am new for the Oracle. As u said, my problem starts from
>the shutting down the database or Instance. I am using the server
>manager. svrmgr23.exe for it. the Instace = CFE.
> I connected as sys/manager_at_cfe which has the DBA privilages with ADM
option.
> now i am typing the
>svrmgr> shutdown -sid ORCL ( I done know the -SHUTTYPE )

I'm more UNIX than NT, but I've run a few NT set-up's, so here goes:

Shell out to DOS. Set the ORACLE_SID to your db (i.e. SET ORACLE_SID=<SID> - put your db sid in there, ORCL or CFE or whatever you called it)

Start up server manager. Login as 'internal'. Use the 'shutdown normal' command.

>
>but it doesn't work. it gives em an error of Illegal Shutdown operation...
>
>And which meanuals and SQL scripts i should look for this problem?
>How can i get trainning for all this.?hope I am asking too much?

Er, the Oracle documentation set. It's about 3 boxes full and 30 manuals worth. Check out the Oracle Press books also. And get some training from Oracle or an Oracle authorised training centre. You look like you need the 'dba' courses.

MotoX.

>
>Again, Thank you very much for your help
>Ashesh.
>
>In article <900313996.12961.0.nnrp-07.c2de712e_at_news.demon.co.uk>,
> "MotoX" <rat_at_tat.a-tat.com> wrote:
>> *First*, perform a *full export and a full cold backup* of your existing
>> database.
>>
>> To delete it, shut it down and remove all the files - look in
dba_data_files
>> for a list. Add the initialisation files and redo log files to the list.
>>
>> To recreate, use the CREATE DATABASE command to get a new instance and
empty
>> database. Look in the manuals for details (creating init files, redo
logs,
>> catalog, etc.) Then use the full export you made. Alternatively, if you
>> already have the creation scripts from your original db, use them, making
>> any modifications you desire first.
>>
>> MotoX.
>>
>> As regards rebuilding
>> ashesh48_at_my-dejanews.com wrote in message
>> <6o5gqc$jb1$1_at_nnrp1.dejanews.com>...
>> >Hi all, How can I drop the existing database and reuse the
>> >objects(logfiles,datafiles etc.) of it and create the new database? and
How
>> >can i delete the old Instance and create new one?Thanks for help in
>> >advance.Ashesh.
>> >
>> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>>
>>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 14 1998 - 11:44:00 CDT