Q
Problem solve Get help with specific problems with your technologies, process and projects.

Errors during creation of test database

I am creating a test database on Oracle 9.2. I looked at the alert file and this message was there: "ORA-1507 signalled during:alter database begin backup" as well as the background process alert file. In that it is showing "ORA-1519 detected in background process. ORA-1519: error while processing file near line."

I am creating a test database on Oracle 9.2. The OS is WinXP. I have got ORA-1092. After that I looked at the alert file and this message was there: "ORA-1507 signalled during:alter database begin backup" as well as the background process alert file. In that it is showing "ORA-1519 detected in background process. ORA-1519: error while processing file near line."

These errors all mean something different and it is not clear from your description in what order they have occurred....

The ORA-1092 error simply means that the Oracle instance was terminated abnormally. The ORA-1507 indicates that an 'alter database' statement was issued against a database that is not mounted. In your case, there was a command issued to 'alter database begin backup' but your database is not mounted.

Finally, the ORA-1519 indicates that a 'create database' statement failed while processing the named file. This error can occur under a number of different circumstances: one is that there is not enough disk space, and another possibility is that the SYS password contains special characters, such as "!" or "-", which are not allowed. Check that you have enough disk space to create the datafiles specified in your create database script. Also, if the SYS password contains special characters, change the password and re-run the create database command.

This was last published in July 2006

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close