IAS 10g : Infrastructure database is unavailable, pls help..

[Krist]

Hi All,

I am new in IAS. I am trying to install IAS 10g (9.0.4), on WIn2000.
both IAS & Infra in same server, one Database.
It used to be running, but today it won't start.

Here is the error :

Application Server Control :
Status = Down
Farm=Infrastructure database is unavailable
(but using sqlplus, I have succesfully log-in into that
'Infrastructure database')

Components :
Forms -> Unavailable
OC4J_BI_Forms -> Unavailable
Reports Server: rep_sysloginfra -> Status = [inprogress, timer symbol]
.... this is forever...

When I Click Logs ->
Error
Error displaying Log Files page. Failed to initialize configuration
management user session.. Database operation failed.
Root Cause: Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=151000065)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
Resolution: . Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=151000065)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))

--------------
Still in Application Server Control, When I click Forms I see this
error on screen :
500 Internal Server Error
java.lang.NullPointerException
at oracle.forms.em.FormsConfigResource.getDefaultSection(Unknown
Source)
at oracle.forms.em.FormsConfigResource.getAllowNewConnectionsEntity(Unknown
Source)
at oracle.forms.em.FormsResources.getAllowNewConnections(Unknown
Source)
at _forms._formsStatusFrame._jspService(_formsStatusFrame.java:127)
[/forms/formsStatusFrame.jsp]
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:778)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:


317)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
at java.lang.Thread.run(Thread.java:534)


---------------
java.lang.NullPointerException
at oracle.forms.em.FormsConfigResource.getDefaultSection(Unknown
Source)
at oracle.forms.em.FormsConfigResource.getEmMode(Unknown Source)
at oracle.forms.em.FormsResources.getResponseTime(Unknown Source)
at _forms._formsResponseFrame._jspService(_formsResponseFrame.java:129)
[/forms/formsResponseFrame.jsp]
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:778)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)

What should I do ?

Thank you for your help,
Krist

[Frank van Bortel]

Krist wrote: Hi All, I am new in IAS. I am trying to install IAS 10g (9.0.4), on WIn2000. both IAS & Infra in same server, one Database. It used to be running, but today it won't start. Here is the error : Application Server Control : Status = Down Farm=Infrastructure database is unavailable (but using sqlplus, I have succesfully log-in into that 'Infrastructure database') Components : Forms -> Unavailable OC4J_BI_Forms -> Unavailable Reports Server: rep_sysloginfra -> Status = [inprogress, timer symbol] ... this is forever... When I Click Logs -> Error Error displaying Log Files page. Failed to initialize configuration management user session.. Database operation failed. Root Cause: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=151000065)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4)))) Resolution: . Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=151000065)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
[snip!]

Error CODE=12514 resembles remarkably a network error:
oerr tns 12514
12514, 00000, "TNS:listener could not resolve SERVICE_NAME
given in connect descriptor"
// *Cause: The SERVICE_NAME in the CONNECT_DATA was not found in
// the listener's tables.
// *Action: Check to make sure that the SERVICE_NAME specified is correct.
// *Comment: This error will be returned if the (database) service has
not been
// registered with the listener; a database instance that is part of this
// service may need to be started or configured properly.

Time to clean up your network (99% guess: your paths changed due
to a reboot - you last installed program is now first, which wasn't
the case before)
--
Regards,
Frank van Bortel

[Krist]

Hi Frank,
Thanks for your reply.
I think the SERVICE_NAME and database instance is fine and started up
properly because I have succesfully log-in from sqlplus using sys
account.

I have not mentioned, after the reboot, my NIC on the server is not
detected, the server lose network connection, so I have to replug,
redetect, and resetting the network connection of the server. But the
the IP remain the same.
Does this give any clue to this problem ?

What do you mean by clean up my network ?
Nothing has been installed before the rebooting.

Thank you for your help,
Krist

[Frank van Bortel]

xtanto@hotmail.com wrote: Hi Frank, Thanks for your reply. I think the SERVICE_NAME and database instance is fine and started up properly because I have succesfully log-in from sqlplus using sys account. I have not mentioned, after the reboot, my NIC on the server is not detected, the server lose network connection, so I have to replug, redetect, and resetting the network connection of the server. But the the IP remain the same. Does this give any clue to this problem ? What do you mean by clean up my network ? Nothing has been installed before the rebooting. Thank you for your help, Krist

You have 2 environments:
- iAS
- RDBMS
Both come with their own copies of SQL*Plus and
Network stack.
The fact, that you can connect, using SQL*Plus only
signifies one environment is correct.

However - the other is *not*! This you have found out.

Please search for tnsnames.ora files - you will at least
have 2. One is correct - the other is not.

***Make a copy for reference, before you start tinkering.***

The most basic thing is to copy one over to the other
environment and retry.
--
Regards,
Frank van Bortel

[Thierry PLASSART]

Hello,

We have met exactly your problem!!

Here's how we get through:

Make sure your FINAL Oracle_home is the infrastructure's home (you will have
to change it manually after install)
Then, regarding services, you'll have to put a start dependency between (mid
tier)ProcessManager et (infra)ProcessManager; (Mid tier) shall not start
before (infra) has fnished to...
To do this, use regedit, go to HKLM\CurrentControlSet\services\(mid
tier)ProcessManager and add a REG_MULTI_SZ component named DependOnService;
its value will be "(infra)ProcessManager"

A complete procedure is available on OTN: it concerns 10gAS R1 and is named
"Oracle Application Server 10g Managing Multiple Oracle Application Server
Instances on a Single Host 10g (9.0.4.1)"
http://download.oracle.com/docs/html/B13992_02/toc.htm (you'll need an
account to get the doc)

Keep trying !!! The road will be long...

Thierry



"Krist" <xtanto@hotmail.com> a écrit dans le message de
news:cb48a3b.0503150329.7c0bb251@posting.google.com... Hi All, I am new in IAS. I am trying to install IAS 10g (9.0.4), on WIn2000. both IAS & Infra in same server, one Database. It used to be running, but today it won't start. Here is the error : Application Server Control : Status = Down Farm=Infrastructure database is unavailable (but using sqlplus, I have succesfully log-in into that 'Infrastructure database') Components : Forms -> Unavailable OC4J_BI_Forms -> Unavailable Reports Server: rep_sysloginfra -> Status = [inprogress, timer symbol] ... this is forever... When I Click Logs -> Error Error displaying Log Files page. Failed to initialize configuration management user session.. Database operation failed. Root Cause: Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=151000065)(ERR=12514)(ERROR_STACK=(ERROR=(
CODE=12514)(EMFI=4)))) Resolution: . Io exception: Connection
refused(DESCRIPTION=(TMP=)(VSNNUM=151000065)(ERR=12514)(ERROR_STACK=(ERROR=(
CODE=12514)(EMFI=4)))) -------------- Still in Application Server Control, When I click Forms I see this error on screen : 500 Internal Server Error java.lang.NullPointerException at oracle.forms.em.FormsConfigResource.getDefaultSection(Unknown Source) at
oracle.forms.em.FormsConfigResource.getAllowNewConnectionsEntity(Unknown Source) at oracle.forms.em.FormsResources.getAllowNewConnections(Unknown Source) at _forms._formsStatusFrame._jspService(_formsStatusFrame.java:127) [/forms/formsStatusFrame.jsp] at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispa
tcher.java:778) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReq
uestDispatcher.java: 317) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandle
r.java:790) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableRe
sourcePooledExecutor.java:186) at java.lang.Thread.run(Thread.java:534) --------------- java.lang.NullPointerException at oracle.forms.em.FormsConfigResource.getDefaultSection(Unknown Source) at oracle.forms.em.FormsConfigResource.getEmMode(Unknown Source) at oracle.forms.em.FormsResources.getResponseTime(Unknown Source) at _forms._formsResponseFrame._jspService(_formsResponseFrame.java:129) [/forms/formsResponseFrame.jsp] at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispa
tcher.java:778) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletReq
uestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandle
r.java:790) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind[Oracle Application Server Containers for J2EE 10g
(9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableRe
sourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534) What should I do ? Thank you for your help, Krist