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

Newuser1

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,

Gianni Ceresa

Hi,

Did you try searching in MOS (My Oracle Support)?

They have few matching document covering this error like for example https://support.oracle.com/epmos/faces/DocumentDisplay?id=1966781.1

Syedsalmancs110

a) Check connection to your scheduler schema,is it working, you can get scheduler schema details from EM.

Log in to Enterprise Manager>>Navigate to Coreapplication>>Open Deployment tab, navigate to scheduler

b) Check if there is firewall enabled between your OBIEE and database server, if so then you would need to set below parameter in your sqlnet.ora file of OBIEE environment under location <<MIDDLE WARE HOME>/Oracle_BI1/network/admin, if sqlnet.ora doesn't exists at this location then create a file with the name sqlnet.ora and declare below parameter in same.

DISABLE_OOB=ON

Newuser1

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,

Syedsalmancs110

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

Hi Sayed,

Thanks for your help.

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

Thanks,