1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Connect Oracle XE database with Oracle 6i Developer

Discussion in 'Server Administration and Options' started by professional, Aug 7, 2008.

  1. professional

    professional Active Member

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    80
    If you install a Express Edition(XE) database and Oracle 6i developer you need to run theese commands @ database side in order to have a successful connection
    Code (Text):

    connect "AS SYSDBA" in sqlplus.

    SHUTDOWN IMMEDIATE;
    STARTUP MOUNT;
    ALTER SYSTEM ENABLE RESTRICTED SESSION;
    ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
    ALTER SYSTEM SET AQ_TM_PROCESSES=0;
    ALTER DATABASE OPEN;
    ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
    SHUTDOWN;
    STARTUP RESTRICT;
    SHUTDOWN;
    STARTUP;
     
    and thats it :)
     
  2. shadow24

    shadow24 Guest

    You are smart person, I really appreciate your help and support
    but How I can do same thing for XE 11g???
    It does not work though
    any idea on how to connect XE11g with Developer6i ????