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

Error message when using utility SAPDBA

I was adding a data file to my tablespace PSAPBWP using the utility SAPDBA. Well after giving the start command for the addition of datafile, an error occurred at the last line. I don't understand how or why this error has occurred. Here is the error message:
---------------------------------------
SAPDBA: 2005-03-07 14.58.13 - trying to ALTER TABLESPACE PSAPBWP ...


SAPDBA: ALTER SYSTEM SWITCH LOGFILE ...

SAPDBA: Directory created:
        '/oracle/BWP/sapreorg/0503071456'
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/BWP/sapreorg/0503071456/cntrl.old'

SAPDBA: Directory created:
        '/oracle/BWP/sapdata2/bwp_153'

SAPDBA: Running command:
ALTER TABLESPACE "PSAPBWP" ADD DATAFILE '/oracle/BWP/sapdata2/bwp_153/bwp.data153' SIZE 2048000K

************************
ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/BWP/sapreorg/0503071456/cntrl.new'

SAPDBA: 2005-03-07 14.59.20 - tablespace PSAPBWP altered, 1 data file added.


SAPDBA: SELECT FILE#,BYTES/1024 FROM V$DATAFILE WHERE NAME='/oracle/BWP/sapdata2/bwp_153/bwp.data153'

ORA-00235: controlfile fixed table inconsistent due to concurrent update
           (2005-03-07 14.59.21)

SAPDBA: Warning - couldn't find all information
        of '/oracle/BWP/sapdata2/bwp_153/bwp.data153'
        for the structural log file!
        Press 
  
    to continue ... 
  
SAPDBA tries to determine the status of the data file by querying the data dictionary. It looks like SAPDBA was unable to do so. The Oracle error message suggests that there was another session making structural changes to the database at the same time as when the data file was added. Was there another SAPDBA running at the same time? That would be the problem.
This was last published in March 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

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

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close