Skip to Content
avatar image
Former Member

DBUA ORA-01950 error in Upgrading oracle server step

Hi All,

Scenarion:

ECC System Copy:

1. DB Restore & Recovery completed successfully.

2. Stared Oracle Version upgrade from 11202 to 11203.

After successful DB restore & recovery on Oracle 11202, I have installed oracle 11203 and started the DBUA & during Upgrading oracle server phase it is giving error ORA-01950: no privilages on tablespace 'HBC_USERS'.

tail trace.log

[Thread-50] [ 2014-02-01 03:58:03.352 EST ] [OracleHome.getVersion:889]  OracleHome.getVersion called.  Current Version: 11.2.0.3.0

[Thread-50] [ 2014-02-01 03:58:03.352 EST ] [OracleHome.getVersion:957]  Current Version From Inventory: 11.2.0.3.0

[Thread-50] [ 2014-02-01 03:58:03.352 EST ] [SQLEngine.getEnvParams:565]  NLS_LANG: AMERICAN_AMERICA.UTF8

[Thread-50] [ 2014-02-01 03:58:03.353 EST ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...

[Thread-50] [ 2014-02-01 03:58:03.364 EST ] [SQLEngine.initialize:362]  m_bReaderStarted: false

[Thread-50] [ 2014-02-01 03:58:03.365 EST ] [SQLEngine.initialize:366]  Starting Reader Thread...

[Thread-50] [ 2014-02-01 03:58:03.367 EST ] [SQLEngine.initialize:415]  Waiting for m_bReaderStarted to be true

[Thread-66] [ 2014-02-01 04:02:57.255 EST ] [BasicStep.handleNonIgnorableError:430]  oracle.sysman.assistants.util.UIMessageHandler@1b78efd8:messageHandler

[Thread-66] [ 2014-02-01 04:02:57.256 EST ] [BasicStep.handleNonIgnorableError:431]  ORA-01950: no privileges on tablespace 'HBC_USERS'

It seems I have to check the user access for corresponding tablespace.

Now my doubt is can I cancel/Abort the DBUA and do the correction and start DBAU again?

Please advice.

Regards

RM

Capture.JPG (34.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 01, 2014 at 12:15 PM

    please click on ignore and check it.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rajat,

      My suggest is to wait and evaluate what tablespace is HBC_USERS. It looks to be a custom tablespace but you need to check whether any application is still using this tablespace or it is obselete.

      If the tablespace is obselete then you may ignore and proceed.

      If the tablespace is in use, then you may need to provide necessary grants for this tablespace for upgrade to proceed.

      Hope this helps.

      Regards,

      Deepak Kori

  • Feb 01, 2014 at 11:47 PM

    Hello Rajat

    What you see is a warning and not an error.

    I would select the ignore option and continue with the upgrade.

    Once the upgrade is completed check whether this tablespace is really required or not.

    Looking at the naming convention it is not a standard SAP tablespace.

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded