Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    45

    Unanswered: deleting a database manually

    Hi,

    I would like to delete my db manually from my unix box, within my Oracle directory. I want to delete all the files pertaining to that db. Are those the steps to follow?

    shutdown the db
    stop the listener
    delete all the *.dbf, *.ctl and redo.log files

    What else and in what order?

    Thanks.

    Ps: How does one invoke Database config assistant in unix? I have a directory /export/home/oracle/product/8.1.7/assistants/dbca/ but there is nothing in there that can be invoked as a GUI to create a new db or delete one.

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204

    Re: deleting a database manually

    Originally posted by alexxx15
    Hi,

    I would like to delete my db manually from my unix box, within my Oracle directory. I want to delete all the files pertaining to that db. Are those the steps to follow?

    shutdown the db
    stop the listener
    delete all the *.dbf, *.ctl and redo.log files

    What else and in what order?

    Thanks.

    Ps: How does one invoke Database config assistant in unix? I have a directory /export/home/oracle/product/8.1.7/assistants/dbca/ but there is nothing in there that can be invoked as a GUI to create a new db or delete one.
    There are also config files and log files that pertain to the database. Their location depends on choices made when creating the database, but there will be a directory called <SID>. In this directory, there will be other directories like udump, cdump, bdump, pfile and others. You can remove them all if you don't need them anymore. The <SID> directory can often times be found under $ORACLE_BASE/admin.

    dbca is located in $ORACLE_HOME/bin. Run dbca to add/remove databases.

    HTH,
    Patrick

  3. #3
    Join Date
    Mar 2003
    Posts
    45

    ORA-01161: database name SEED ....

    Hi,

    When I created my db, it was during Oracle8i installation. The name given to both the DB_name is rich and SID is rich. Now I get this error when I try to create the controlfile, which were not created during the installation:

    I run this;

    CREATE CONTROLFILE DATABASE rich RESETLOGS ARCHIVELOG
    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
    LOGFILE
    GROUP 1 '/export/home/oracle/oradata/rich/REDO03.LOG' SIZE 1M,
    GROUP 2 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M,
    GROUP 3 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M
    DATAFILE
    '/export/home/oracle/oradata/rich/system01.dbf' SIZE 270M,
    '/export/home/oracle/oradata/rich/rbs01.dbf' SIZE 5M,
    '/export/home/oracle/oradata/rich/temp01.dbf' SIZE 5M,
    '/export/home/oracle/oradata/rich/tools01.dbf' SIZE 5M,
    '/export/home/oracle/oradata/rich/indx01.dbf' SIZE 5M,
    '/export/home/oracle/oradata/rich/users01.dbf' SIZE 5M,
    '/export/home/oracle/oradata/rich/drsys01.dbf' SIZE 5M
    CHARACTER SET WE8ISO8859P1;


    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01161: database name SEED in file header does not match given name of RICH
    ORA-01110: data file 1: '/export/home/oracle/oradata/rich/system01.dbf'



    According to Oarcle, this means that db_name is something other than "rich" I tried, 'RICH', local but neither of those work. At this point, how could I look at the file header to find the name, if my database is not complete?


    ORA-01161: database name name in file header does not match given name of name
    Cause: The database name given at the command line does not match the database name found in the file header. The database name specified at the command line is incorrect.

    Action: Enter the command again with the correct name for the database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •