DBUA ORA-01950 error in Upgrading oracle server step

[Former Member]

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

[Reagan]

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

[Former Member]

please click on ignore and check it.

[Former Member]

Yes, can do it, but at latter stage it can give more error, then the DB will be unusable.

Is it possible to restart DBUA at this point? Did you faced this kind of secnario before.

[former_member188883]

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