Install 10g on a PC with 9.2.04

[CaoCao]

My PC is currently running 9.2.0.1 on Windows XP. Can I install 10g on different ORACLE_HOME and I can run both 9iR2 and 10g on the same PC? Is there any incompatibility? Tks.

[KenEwald]

10g is awesome. 10g ASM is really fantastic!

No compatability problem. In fact if you want to use Grid Control (10g Enterprise Manager) the repository cannot sit on a 10g database .. and since 10g doesn't talk to 8.1.7.3 or earlier versions, you're left with 8.1.7.4 thru 9.2.0.5

However if you only run a single 10g database on that server, you can use "Database Control" to manage it. Just remember, one server, one instance, only one "Database control". Add another instance and you'll have to pick which one to manage. There is an alternative though... you can stop the dbconsole, reset your ORACLE_SID, and startup the other instance's dbconsole. It's a mess.

Best of luck. 10g release 2 is due out in June (Ken Jacobs interview on SearchOracle.com) We're hoping to see a few of these things cleared up.

[KenEwald]

Oh, and if you're using 9i OEM, you won't be able to manager 10g db's. You'll see them but they just won't expand.

[Roh]

I am trying to do an import and export from Oracle 10g instatnce to the same instance.

I created a directory at the OS level c:\test_dir

sql>connect sys/passwd@orcl10g as sysdba

sql>alter user scott identified by tiger account unlock;

sql>Grant create any directory to scott;

sql>create or replace director example_dir as 'c:\test_dir\';

sql>Grant read,write on directory example_dir to scott;

oracle>expdb scott\tiger@orcl10g schemas=scott directory=test_dir dumpfile=expdbscott.log logfile=expdbemp_dept.log
and this created a dump file in c:\test_dir

now can you help me to import this to HR Schema with the impdb commands.

[DaPi]

Originally posted by KenEwald
10g is awesome. . .
. . . . if you want to use Grid Control (10g Enterprise Manager) the repository cannot sit on a 10g database . .

That's "awesome"?

[pando]

Originally posted by DaPi
That's "awesome"?

crap0la