[es] - oracle_home problem

suadhm
Suad Adrović
Podgorica

Član broj: 90644
Poruke: 339
*.crnagora.net.

Profil

^{22.07.2009. u 11:11 - pre 179 meseci}

Na jednom serveru imam instaliran Oracle AS i Oracle 10g bazu podataka.OS je Windows Server 2003 SP2. Sve radi OK osim Oracle DB EM-a.
Kada se pokrene EM dobijam gešku:

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

I dole piše da su instanca, listener i agent podignuti, ali ništa više ne mogu uraditi.

Ovaj problem sam primijetio odmah posle instalacije ali sam ga zanemario, medjutim, nekim čudom, EM je odjedno proradio jedno mjesec dana, ali nakon reseta servera opet se vratio na staro.

Pretpostavljam da je problem u ORACLE_HOME, izgleda da je default-ni ovaj od AS-a. Jer iako kroz CMD setujem i SID i bazni ORACLE_HOME to se
iz nekog razloga ne reflektuje na sistem.

AS ORACLE_HOME je: C:\oracle\Ora10g_AS
DB ORACLE_HOME je: D:\oracle\product\10.2.0\db_1

Enviroment PATH je:

Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\oracle\Ora10g_AS
\jdk\jre\bin\classic;C:\oracle\Ora10g_AS\jdk\jre\bin;C:\oracle\Ora10g_AS\bin;C:\
oracle\Ora10g_AS\jlib;D:\oracle\product\10.2.0\db_1\bin;C:\Program Files\HP\NCU;
C:\oracle\Ora10g_AS\jdk\bin

Kada pokušam da kroz CMD pokrenem Oracle DBConsole: emctl start dbconsole, iako je setovan ORACLE_HOME na D:\oracle\product\10.2.0\db_1,
dobijam grešku:

OC4J Configuration issue. C:\oracle\Ora10g_AS/oc4j/j2ee/OC4J_DBConsole not found
.

Kada probam komandu: emctl, dobijam sledeće:

Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.3.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Invalid arguments

Unknown command option "" or component ""
Usage::
Oracle Enterprise Manager 10g Application Server Control commands:
emctl start| stop| status iasconsole
emctl set password [<old ias_admin password> <new ias_admin password>]
emctl secure iasconsole
emctl config iasconsole port [portNumber]
emctl config iasconsole rmiport [portNumber]
emctl config agent credentials [<Target_name>[:<Target_Type>]]
emctl config agent port [portNumber]

Tj. sistem gleda AS ORACLE_HOME????

Kada iz foldera D:\oracle\product\10.2.0\db_1\bin pokrenem: emctl, dobijam:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Invalid arguments

Unknown command option
Usage::
Oracle Enterprise Manager 10g Database Control commands:
emctl start| stop| status| setpasswd dbconsole
emctl secure <options>

emctl set ssl test|off|on em
emctl set ldap <host> <port> <user dn> <user pwd> <context dn>
emctl blackout options can be listed by typing "emctl blackout"
emctl config options can be listed by typing "emctl config"
emctl secure options can be listed by typing "emctl secure"
emctl ilint options can be listed by typing "emctl ilint"
emctl deploy options can be listed by typing "emctl deploy"

Iz ovog foldera bez problema odradi sve emctl komande, ali ni to ne pomaže jer EM i dalje ne radi kako treba.

Probao sam da setujem defaultni ORACLE_HOME ali nisam našao ORACLE HOME Selector GUI iz Programs menia.
Takodje sam, po upustvu koje sam našao na netu, probao da promijenim ključ u Registry-u ali ne mogu da nadjem:

HKEY_LOCAL_MACHINE -> Software -> Oracle -> ALL_HOMES

Ali kod mene ne postoji ovo ALL_HOMES.

Ja imam samo:

HKEY_LOCAL_MACHINE -> Software -> Oracle -> iSuites
-> JInitiator
-> KEY_Ora10g_AS
-> KEY_OraDb10g_home1
-> SYSMAN

Ima li neko ideju kako da ovo napravim?

_{[Ovu poruku je menjao suadhm dana 22.07.2009. u 12:35 GMT+1]}

Odgovor na temu

djoka_l
Beograd

Član broj: 56075
Poruke: 3453

Jabber: djoka_l

+1462 Profil

Re: oracle_home problem

^{22.07.2009. u 12:38 - pre 179 meseci}

Citat:

Enviroment PATH je:

Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\oracle\Ora10g_AS
\jdk\jre\bin\classic;C:\oracle\Ora10g_AS\jdk\jre\bin;C:\oracle\Ora10g_AS\bin;C:\
oracle\Ora10g_AS\jlib;D:\oracle\product\10.2.0\db_1\bin;C:\Program Files\HP\NCU;
C:\oracle\Ora10g_AS\jdk\bin

Kada pokušam da kroz CMD pokrenem Oracle DBConsole: emctl start dbconsole, iako je setovan ORACLE_HOME na D:\oracle\product\10.2.0\db_1,
dobijam grešku:

OC4J Configuration issue. C:\oracle\Ora10g_AS/oc4j/j2ee/OC4J_DBConsole not found

Ovo se očigledno dešava zato što je u PATH-u prvo AS bin katalog, pa tek onda DB bin, tj. nema veze sa ORACLE_HOME. Probaj da promeniš PATH, tako da staviš D:\oracle ispred C:\oracle.

Što se tiče ALL_HOMES to su koristili stariji proizvodi, evo kada ja pogledam u moj registry, tu su se ubacili Developer 6i, Designer6i i još koješta, dok su mi, na primer, XE i 10g u ključevima KEY_XE i KEY_Db10g.

Ajde probaj prvo da središ PATH, pa da se dalje mučimo...

Odgovor na temu

suadhm
Suad Adrović
Podgorica

Član broj: 90644
Poruke: 339
*.crnagora.net.

Profil

Re: oracle_home problem

^{22.07.2009. u 13:12 - pre 179 meseci}

Već sam probao sa promjenom redosleda putanja u PATH-u, ali ni to nije rešenje za EM.
Sada je na sistemu default-ni DB HOME.

Čudno je što je ovo radilo do reseta servera.

Evo i dijela sadržaja EM log fajla emoms.log:

2009-07-22 14:00:55,196 [HttpRequestHandler-9564382] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

2009-07-22 14:00:55,212 [HttpRequestHandler-9564382] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

2009-07-22 14:00:55,212 [HttpRequestHandler-9564382] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://db.domen.local:3938/emd/main)(ERROR = INTERNAL_ERROR)
2009-07-22 14:00:55,259 [HttpRequestHandler-14425860] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

2009-07-22 14:00:55,274 [HttpRequestHandler-14425860] ERROR eml.OMSHandshake getParameterFromDB.402 - ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

2009-07-22 14:00:55,290 [HttpRequestHandler-14425860] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://db.domen.local:3938/emd/main)(ERROR = INTERNAL_ERROR)
2009-07-22 14:00:58,915 [HttpRequestHandler-9564382] ERROR conn.ConnectionService verifyRepositoryEx.433 - Invalid Connection Pool. ERROR = ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

2009-07-22 14:00:58,915 [EMUI_14_00_58_/console/aboutApplication] ERROR em.console doGet.311 - java.lang.IllegalStateException: Response has already been committed
java.lang.IllegalStateException: Response has already been committed
at com.evermind.server.http.EvermindHttpServletResponse.resetBuffer(EvermindHttpServletResponse.java:1901)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:211)
at oracle.sysman.emSDK.svlt.PageHandler.render(PageHandler.java:773)
at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:396)
at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688)
at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291)
at oracle.sysman.eml.app.Console.doGet(Console.java:135)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:101)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:123)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:239)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)

Odgovor na temu