Home » RDBMS Server » Server Administration » Drop database in Oracle 9i (merged)
Drop database in Oracle 9i (merged) [message #253394] Mon, 23 July 2007 14:26 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi everybody,

could anybody please help me out how to drop the database.

what are the prerequisites to drop the oracle 9i database.

Regards
Balaji
Re: Drop Database [message #253395 is a reply to message #253394] Mon, 23 July 2007 14:31 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount exclusive
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size             100664912 bytes
Database Buffers          180355072 bytes
Redo Buffers                2973696 bytes
Database mounted.

SQL> alter system enable restricted session;

System altered.

SQL> exit

$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 7 17:33:25 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1123903688, not open)

RMAN> drop database including backups;

database name is "ORCL" and DBID is 1123903688

Do you really want to drop all backups and the database (enter YES or NO)? YES
Re: Drop Database [message #253420 is a reply to message #253395] Mon, 23 July 2007 16:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The DROP DATABASE command isn't available in 9i. However, you can you DBCA to delete a database in 9i.
Re: Drop Database [message #253452 is a reply to message #253420] Tue, 24 July 2007 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Or use the rm command!

Regards
Michel
DROP DATABASE in ORACLE9I [message #253559 is a reply to message #253394] Tue, 24 July 2007 05:10 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



hi friends,

i want to drop my existing database 'BALAJI'in oracle9i . when i executed all these commands , i find error in the drop database command.

STARTUP MOUNT EXLUSIVE

ALTER SYSTEM ENABLE RESTRICTED SESSION

DROP DATABASE 'BALAJI'

ORA-02026: MISSING LINK KEYWORD (BALAJI)

could anybody helpme to solve this issue.

Regards,
Balaji
Re: DROP DATABASE in ORACLE9I [message #253561 is a reply to message #253559] Tue, 24 July 2007 05:15 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Drop Database command is not available in 9i . Use DBCA.
Re: DROP DATABASE in ORACLE9I [message #253562 is a reply to message #253559] Tue, 24 July 2007 05:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

U posted this topic earlier.!!!!
DROP DATABASE IN ORACLE9I [message #253564 is a reply to message #253394] Tue, 24 July 2007 05:34 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



hi friends,

when i tried to drop my existing database "BALAJI" i received error" missing link in BALAJI).The following are the commands which i executed to drop my existing database .

startup mount exclusive

alter system enable restricted session

drop database BALAJI

could anybody helpme to sove the above issue.

Regards,
Balaji
Re: DROP DATABASE IN ORACLE9I [message #253585 is a reply to message #253564] Tue, 24 July 2007 06:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As already said drop database does not exist in 9i.
Use "rm" if you don't want to use dbca.

Regards
Michel
Re: DROP DATABASE IN ORACLE9I [message #253689 is a reply to message #253585] Tue, 24 July 2007 11:10 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi friends,

im currently using oracle9i database on winwdows. how to drop the existing database on windows.

help me to solve this issue.

Regards,
Balaji

Re: DROP DATABASE IN ORACLE9I [message #253693 is a reply to message #253689] Tue, 24 July 2007 11:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
in cmd type DBCA then select delete database then select database name then select next and then finish.
or use
Format c:/q/s

[Updated on: Tue, 24 July 2007 11:17]

Report message to a moderator

Re: DROP DATABASE IN ORACLE9I [message #253696 is a reply to message #253689] Tue, 24 July 2007 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
C:\>del /?
Supprime un ou plusieurs fichiers.

DEL [/P] [/F] [/S] [/Q] [/A[[:]attributs]] noms
ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributs]] noms

  noms          Spécifie une liste d'un ou plusieurs fichiers ou répertoires.
                Les caractères génériques peuvent être utilisés pour
                supprimer plusieurs fichiers. Si un répertoire est spécifié,
                tous les fichiers qu'il contient seront supprimés.

  /P            Demande une confirmation avant de supprimer un fichier.
  /F            Force la suppression de fichiers en lecture seule.
  /S            Supprime les fichiers dans tous les sous-répertoires.
  /Q            Pas de confirmation avant suppression avec car. génériques.
  /A            Suppression en fonction des attributs
  attributs     R  Fichiers en lecture seule   S  Fichiers système
                H  Fichiers cachés             A  Fichiers prêts pour archive
                -  Préfixe de négation

Si les extensions de commandes sont activées, DEL et ERASE sont modifiées
comme suit :
La logique d'affichage du commutateur /S est inversée. Elle
n'affiche que les fichiers supprimés, et pas ceux qui n'ont pas été trouvés.

Sorry for french but you can do the same on your platform.

Regards
Michel
Re: DROP DATABASE IN ORACLE9I [message #253757 is a reply to message #253689] Tue, 24 July 2007 15:01 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thank you
Re: DROP DATABASE IN ORACLE9I [message #253845 is a reply to message #253757] Wed, 25 July 2007 01:40 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

C:\>DEL /?
Deletes one or more files.

DEL [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names
ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names

  names         Specifies a list of one or more files or directories.
                Wildcards may be used to delete multiple files. If a
                directory is specified, all files within the directory
                will be deleted.

  /P            Prompts for confirmation before deleting each file.
  /F            Force deleting of read-only files.
  /S            Delete specified files from all subdirectories.
  /Q            Quiet mode, do not ask if ok to delete on global wildcard
  /A            Selects files to delete based on attributes
  attributes    R  Read-only files            S  System files
                H  Hidden files               A  Files ready for archiving
                -  Prefix meaning not

If Command Extensions are enabled DEL and ERASE change as follows:

The display semantics of the /S switch are reversed in that it shows
you only the files that are deleted, not the ones it could not find.


icon5.gif  Re: Drop database in Oracle 9i (merged) [message #268613 is a reply to message #253394] Wed, 19 September 2007 02:58 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
Quote:

D:\>echo %ORACLE_SID%
db01

D:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Sep 19 15:54:57 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount exclusive
ORACLE instance started.

Total System Global Area 529604804 bytes
Fixed Size 454852 bytes
Variable Size 411041792 bytes
Database Buffers 117440512 bytes
Redo Buffers 667648 bytes
Database mounted.

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

D:\>rman target /

Recovery Manager: Release 9.2.0.8.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: DB01 (DBID=1258421116)

RMAN> drop database including backups;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "database": expecting one of: "catalog"
RMAN-01007: at line 1 column 6 file: standard input

RMAN>




Can you guys help me out? I'm trying to drop the database via RMAN. Did I miss something?
Re: Drop database in Oracle 9i (merged) [message #268614 is a reply to message #253394] Wed, 19 September 2007 03:01 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

review this topic from first.
Re: Drop database in Oracle 9i (merged) [message #268618 is a reply to message #268614] Wed, 19 September 2007 03:16 Go to previous messageGo to next message
kelvs
Messages: 15
Registered: December 2006
Junior Member
Arju wrote on Wed, 19 September 2007 16:01
review this topic from first.


Hi Arju,

I think you're referring to this:

Quote:
The DROP DATABASE command isn't available in 9i. However, you can you DBCA to delete a database in 9i.


Yah, was thinking about what Michael posted:

Quote:


Or use the rm command!

Regards
Michel




is he referring to rm command of unix or RMAN?

how about the database registered in RMAN? do we have to manually unregister it before deleting the database? or just delete the database upfront? Smile


Re: Drop database in Oracle 9i (merged) [message #268620 is a reply to message #253394] Wed, 19 September 2007 03:21 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

rm command of OS. Available in Unix. If you have windows you can use graphical window to delete or command prompt.
Re: Drop database in Oracle 9i (merged) [message #268623 is a reply to message #253394] Wed, 19 September 2007 03:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You will use OS command. Don't bother about RMAN register or unregister.
Re: Drop database in Oracle 9i (merged) [message #268627 is a reply to message #253394] Wed, 19 September 2007 03:37 Go to previous message
kelvs
Messages: 15
Registered: December 2006
Junior Member
big thanks arju

now, things became clear to me. Smile
Previous Topic: upgrade 9i to 10g using DBUA
Next Topic: Audit Trail specific action
Goto Forum:
  


Current Time: Mon Dec 02 07:16:27 CST 2024