Reg: Oracle BI Scheduler Error: [nQSError: 76015] error

Question

Hi All,

All of a sudden getting below error when we try to run agent in OBI application and BI Scheduler server was up and running fine. Can anyone suggest on this.

version we are using ; OBIEE 11.1.1.7.1

Oracle BI Scheduler Error: [nQSError: 76015] The active Oracle BI Scheduler instance in the Cluster Could not be determined.

Thanks in Advance,

Newuser1 · Answer

Hi Sayed,

Thanks for your help.

After increasing space in the drive and fresh restart of services resolves the issue.

Thanks,

Syedsalmancs110 · Answer

Hello There,

Looking at log message it looks like the problem is caused by Oracle unable or fails to find sufficient contiguous space to allocate INITIAL extent for segment being created, due to the data files for a tablespace specified in tablespace_name(UAT_BIPLATFORM) has become full, or there is not enough space in the datafile.

Check with your DBA for suitable way to resolve this issue, you can refer to below blog for more information on same but do not perform any action without consulting your DBA.

ORA-01658: unable to create INITIAL extent tips

Thanks and Regards,

Syed Hamd Salman

Newuser1 · Answer

Hi Syed,

Thanks for your reply.

Done the changes as suggested but still facing the same issue.Please find the below scheduler logs and can you please suggest on this

[2017-05-24T05:10:32.000+03:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: a70a4720]  [nQSError: 17011] SQL statement execution failed. [[

[nQSError: 17001] Oracle Error code: 1658, message: ORA-01658: unable to create INITIAL extent for segment in tablespace UAT_BIPLATFORM

at OCI call OCIStmtExecute: INSERT INTO S_NQ_ERR_MSG (JOB_ID, INSTANCE_ID, RELATIVE_ORDER, ERROR_MSG_TEXT, DELETE_FLG) VALUES (1, 1, 1, '[nQSError:$_\s_$67011]$_\s_$Instance$_\s_$did$_\s_$not$_\s_$complete.', 0). at stage of execute transaction command with data source: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXXX)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XXXXX)))

]]

[2017-05-24T05:10:32.000+03:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: a70a4720]  [nQSError: 17011] SQL statement execution failed. [[

[nQSError: 17001] Oracle Error code: 1658, message: ORA-01658: unable to create INITIAL extent for segment in tablespace UAT_BIPLATFORM

at OCI call OCIStmtExecute: INSERT INTO S_NQ_ERR_MSG (JOB_ID, INSTANCE_ID, RELATIVE_ORDER, ERROR_MSG_TEXT, DELETE_FLG) VALUES (1, 1, 1, '[nQSError:$_\s_$67011]$_\s_$Instance$_\s_$did$_\s_$not$_\s_$complete.', 0).

]]

Thanks in advance,