Windows装多个ORACLE版本dbca无法建库

blue_prince10 · 发表于 2005-5-24 14:06

不知道大伙有没碰过。新装了台机器，WINDOWS XP PROFESSIONAL。按顺序装了8I、9I、10G。装完后启动10G和8I的DBCA都成功建了库，最后启动9i的DBCA图形化界面一直无法启动，在命令行下运行出现如下的情况：

[php]
D:\\oracle\\ora92\\bin>dbca
Exception in thread "main" java.lang.UnsatisfiedLinkError: initializeCluster
      at oracle.ops.mgmt.nativesystem.WindowsSystem.initializeCluster(WindowsS
ystem.java:390)
      at oracle.ops.mgmt.cluster.GetActiveNodes.initializeCluster(GetActiveNod
es.java:260)
      at oracle.ops.mgmt.cluster.GetActiveNodes$ClusterWareThread.<init>(Compi
led Code)
      at oracle.ops.mgmt.cluster.GetActiveNodes.<init>(GetActiveNodes.java:139
)
      at oracle.ops.mgmt.cluster.GetActiveNodes.create(GetActiveNodes.java:158
)
      at
      at oracle.sysman.assistants.dbca.backend.Host.checkOPS(Host.java:1815)
      at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:469)
      at oracle.sysman.assistants.dbca.ui.UIHost.<init>(UIHost.java:185)
      at oracle.sysman.assistants.dbca.ui.InteractiveHost.<init>(InteractiveHo
st.java:54)
      at oracle.sysman.assistants.dbca.Dbca.getHost(Dbca.java:141)
      at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:85)
      at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:161)
[/php]

然后就停在这边不动了。哪位有碰过类似的情况？

zflying2000 · 发表于 2005-5-24 14:35

有可能,你可以建立不同的用户.因为windows下面的会写一部分信息在注册表中!

花好月不圆 · 发表于 2005-5-24 14:51

java classpath 的路径？

wlidflower · 发表于 2005-5-24 14:54

我的是9I 10G在一起没有问题

花好月不圆 · 发表于 2005-5-24 15:16

Hi,

Do you have multiple versions of Oracle (incl 10g) on the same box?

If so, running everything can be tricky.

Summary:
You can remove 10g paths if you need v9 utilities, or you can hack DDLs, or come up with another solution. Suggestions welcome. But, the hack techniques may simply convince you to take an approach similar to PD's post. :-)

Why? With 10g installed, the home selector technique to order the 'Path' no longer works for v9 dbca if the 'Path' includes both v9 and v10g (client or server) in any order.

<DETAILS IF CURIOUS>
I've found a problem running both 9201 (not patched for these tests) and 10g on the same box where the root cause appeared to be the 'Path' environment variable, and only in the case where the 'Path' includes both 9 and 10g stuff. (Note: PD's post to maintain separate accounts with runas can be used to segregate the 'Path' so these problems will not occur).

But, if you are stuck with a combined 9 and 10g path, here is what I've found.

The 'Path' ordering does not matter (big problem) if you are trying to run the v9 dbca, etc. In the example below, I've created a workaround to run v9 dbca when both v9 and v10g are installed and the 'Path' environment includes both.

The test, run:
G:\oracle\product\9.2.0\Db_9\bin\dbca (this is where I've installed 9201) This fails with "Exception in thread "main" java.lang.UnsatisfiedLinkError: initializeCluster...", because the 'Path' (any order) includes these:

G:\oracle\product\9.2.0\Db_9\bin; (this is where I've installed 9201)
G:\oracle\product\10.1.0\Db_1\bin;
G:\oracle\product\10.1.0\Client_1\bin;

Since the order does not matter, the old trick (v8 and v9) of re-ordering the 'Path' with the home selector would also fail. Bummer.
Solution 1: The simple solution:
When you try to run v9 dbca (or other utilities), the 'Path' may not include: G:\oracle\product\10.1.0\Db_1\bin;
G:\oracle\product\10.1.0\Client_1\bin;
A quick fix to run v9 dbca is to /adjust/ your Path to include only: G:\oracle\product\9.2.0\Db_9\bin; (this is where I've installed 9201)

Solution 2: The *other* way. ;-)
You can run v9 dbca successfully, even if the 'Path' includes v9 and v10 if you *rename* the 10g "orasrvm.DLL" found in any 10g BIN directory. Rename it back after you are done, please.

If you have a 10g Server
G:\oracle\product\10.1.0\Db_1\BIN\orasrvm.DLL Then temporarily rename it to
G:\oracle\product\10.1.0\Db_1\BIN\_orasrvm.DLL (move out of way, and easy to find again)

If you have a 10g Client
G:\oracle\product\10.1.0\Client_1\BIN\orasrvm.DLL Then temporarily rename it to
G:\oracle\product\10.1.0\Client_1\BIN\_orasrvm.DLL (move out of way, and easy to find again)

The test, after hacking every 10g orasrvm.DLL, run: G:\oracle\product\9.2.0\Db_9\bin\dbca
Now works. Its magic. You get the idea, this sucks. ;-)

It works even though my environment 'Path' includes both v9 and v10 stuff.

G:\oracle\product\9.2.0\Db_9\bin; (this is where I've installed 9201)
G:\oracle\product\10.1.0\Db_1\bin;
G:\oracle\product\10.1.0\Client_1\bin;

blue_prince10 · 发表于 2005-5-24 15:24

最初由花好月不圆发布
[B]Hi,

Solution 2: The *other* way. ;-)
You can run v9 dbca successfully, even if the 'Path' includes v9 and v10 if you *rename* the 10g "orasrvm.DLL" found in any 10g BIN directory. Rename it back after you are done, please.

If you have a 10g Server
G:\oracle\product\10.1.0\Db_1\BIN\orasrvm.DLL Then temporarily rename it to
G:\oracle\product\10.1.0\Db_1\BIN\_orasrvm.DLL (move out of way, and easy to find again)

The test, after hacking every 10g orasrvm.DLL, run: G:\oracle\product\9.2.0\Db_9\bin\dbca
Now works. Its magic. You get the idea, this sucks. ;-)

It works even though my environment 'Path' includes both v9 and v10 stuff.

G:\oracle\product\9.2.0\Db_9\bin; (this is where I've installed 9201)
G:\oracle\product\10.1.0\Db_1\bin;
G:\oracle\product\10.1.0\Client_1\bin; [/B]

It works,thannnnnnnnnnks 花好月不圆

keikey · 发表于 2007-2-28 15:56

收藏先，如遇问题可以用上！

lemonlili · 发表于 2007-2-28 16:34

个人认为环境变量问题..