Drop database ORA-01504 Problems

Source: Internet
Author: User

Drop database ORA-01504 problems oracle 11g for win2008dc, drop database. c: \ Users \ Administrator> set nls_lang = AMERICAN_AMERICA.ZHS16GBK C: \ Users \ Administrator> sqlplus "/as sysdba" SQL * Plus: release 11.2.0.3.0 Production on Wed May 8 08:36:45 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> startup mount restiricted; ORACLE instance started. total System Global Area 4275781632 bytesFixed Size 2262048 bytesVariable Size 2650803168 bytesDatabase Buffers 1610612736 bytesRedo Buffers 12103680 bytesORA-01504: database name 'restiricted' does not match parameter db_name 'orcl' SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> startup nomount restrict; ORACLE instance started. total System Global Area 4275781632 bytesFixed Size 2262048 bytesVariable Size 2650803168 bytesDatabase Buffers 1610612736 bytesRedo Buffers 12103680 bytesSQL> alter database mount; Database altered. SQL> drop database; Database dropped. disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> exit C: \ Users \ Administrator>-EOF-

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.