Install 10g on a PC with 9.2.04
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Install 10g on a PC with 9.2.04

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    Install 10g on a PC with 9.2.04

    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.

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  4. #4
    Join Date
    May 2004
    Posts
    1

    Oracle 10g mpdb,expdb

    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.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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"?

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by DaPi
    That's "awesome"?
    crap0la

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width