ORA-01109: Database failed to start problem __ Database

Source: Internet
Author: User

Database failed to start issue

Prompt when logging on to database: Ora-12514:tns: The listener is currently unable to recognize the connection descriptor

Solution:

Then log on to the database server (aix5 Unix), go to the Oracle User (Unix turn user command: su-oracle), enter the Sqlplus/nolog carriage return conn/as SYSDBA Enter the SQL interface, do the following:

1, close the instance

sql> shutdown immediate;

Ora-01109:database not open

Database dismounted.

ORACLE instance shut down.

2. Startup instance

Sql> startup;

Total System Global area 2466250752 bytes

Fixed Size 2022864 bytes

Variable Size 536871472 bytes

Database buffers 1912602624 bytes

Redo buffers 14753792 bytes

Database mounted.

Ora-01157:cannot identify/lock data file 7-see DBWR trace file

Ora-01110:data file 7: '/dbbak/rlv_gcomm_30g_02 '

Then you can log in to the database, but you can't do anything about it, prompting:

Ora-01109:database not open

(Online search, there are some people have this problem, but the problem is someone else's file exists, so just change the path, directly execute the following statement to execute 1 and 2 on it.)

sql> ALTER DATABASE rename file '/dbbak/rlv_gcomm_30g_02 ' to '/var/rlv_gcomm_30g_02 ';

But the problem is my database rlv_gcomm_30g_02 This file does not exist, where the path, after the network and the help of the kind-hearted people can finally find the reason for

The specific reason analysis is as follows: Since the morning created a tablespace, but then directly to delete the table space rlv_gcomm_30g_02 file, but so the deletion is problematic, table space and data files if not deleted from the database, the corresponding data files can not be directly deleted on the server. As a result, there is a problem checking the data when you start the database, which ultimately causes the database to fail to start. The solution is as follows:

3, Sql>alter database datafile '/dbbak/rlv_gcomm_30g_02 ' offline drop;

Then in the implementation of the above 1 and 2 steps on it, because this database also has a database table space files are deleted, so there will be the same problem, of course, as long as the implementation of 3, and then execute 1,2 on it.

Sql> Startup

ORACLE instance started.

Total System Global area 2466250752 bytes

Fixed Size 2022864 bytes

Variable Size 536871472 bytes

Database buffers 1912602624 bytes

Redo buffers 14753792 bytes

Database mounted.

Database opened. It finally worked.

But this time the login database is not enough, but also to start

The

Then you can log on to the database to drop the tablespace.

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.