CTRL Server : ORA-01405 Error (Doc ID 949449.1)

Symptoms

This is a fatal error that occurs when starting the CTRL server (either by itself – starts (-d) $CTRL), or as part of the series of ASAP servers starting when using the standard ASAP startup script start_asap_sys (-d). This could occur at any point during development.

Here, the CTRL server can't start up. Since this is the 1st ASAP server to start in sequence, ASAP won't start.

$ start_asap_sys -d
Starting Master Control Server <CTRL_SERVER_NAME>...
Failed to start Master Control Server <CTRL_SERVER_NAME>

In the CTRL server dialogue file – CTRL${ENV_ID}.diag …

...<cut>...

Connection established to Oracle Server with user <CTRL_USER>and connection <ASAP_DB_NAME>
> />195135.173:55: LOW:ASC_ociopen :123 :ocilib.c
Connection set to non-blocking for user <CTRL_USER>
> />195135.173:55: LOW:ASC_ociopen :135 :ocilib.c
Successfully got the file descriptor for the connection [27]
> />195135.173:55: LOW:ASC_ociopen_cursor :321 :ocilib.c
Successfully opened cursor
> />195135.173:55: LOW:ASC_ociopen :147 :ocilib.c
Configuring Oracle session profile
> />195135.173:55: LOW:ASC_ociparse :432 :ocilib.c
Successfully parsed PLSQL block cursor
> />195135.173:55: LOW:Initialization :966 :main.c
Application Server Initialization Wait Complete
> />195135.173:55:SANE:Thread Start :346 :asc_spawn.c
Startup of Thread [Timer 1], MsqQ [], MsgQId [-1]
> />195135.174:57: LOW:Initialization :966 :main.c
Application Server Initialization Wait Complete
> />195135.174:57:SANE:Thread Start :346 :asc_spawn.c
Startup of Thread [Connection Check], MsqQ [], MsgQId [-1]
> />195135.174:57: LOW:ASC_ociparse :432 :ocilib.c
Successfully parsed PLSQL block cursor
> />195135.175:64: LOW:ASC Process Init :711 :asc_spawn.c
Application Initialization of Thread <CTRL_SERVER_NAME>- (<CTRL_SERVER_NAME>)
> />195135.176:64: LOW:Client Connection :1699:main.c
Connection Received from Client Application:
User [<CTRL_USER>], [********] Machine/Server [<CTRL_SERVER_NAME>-C] Appl [<CTRL_SERVER_NAME>]
> />195135.176:50: LOW:ASC_ocicreate_cmd :517 :ocilib.c
Created PL/SQL statement as follows : begin :retval :=CSP_list_centers(:curs); end;
> />195135.176:50: LOW:ASC_ociparse :432 :ocilib.c
Successfully parsed PLSQL block cursor
> />195135.177:20:SANE:ORACLE ERROR :1130:ocilib.c

-- ORACLE error when processing OCI function OEXEC, OEXN


> />195135.177:20:SANE:ORACLE ERROR :1138:ocilib.c
error message ORA-01405: fetched column value is NULL


> />195135.177:20: LOW:ASC_cprpcexec() :875 :ctlib.c
RPC CSP_get_master failed
> />195135.177:20:SHUT:Control Agent :151 :ctrl_agent.c
Error: 'CSP_get_master' RPC Failed

Checking the Oracle error code (rc = 1405) for this specific error, you can see that it is in response to the empty column in the table.

$ oerr ora 01405
\01405, 00000, "fetched column value is NULL"
// *Cause:
// *Action:

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.