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]