Connect 12c Database with 6i Developer

Connect 12c Database with 6i Developer

Subject: Connectivity between Oracle 12c Database and Oracle 6i Developer 2000

Step 1:

Install Oracle 12c Database with default Character set and default schemas

Step 2:

Configure SQLNET.ORA Database file by adding this line.

·         “SQLNET.ALLOWED_LOGON_VERSION=8”

·         “SQLNET.ALLOWED_LOGON_VERSION_SERVER=8”

·         “SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8”

Step 3:

Setting up some parameter in Oracle Database.

·         Setting the system parameters, JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES, to 0

·         Setting the parameter “SEC_CASE_SENSITIVE_LOGIN” to FALSE

·         Changing the database character set to WE8MSWIN1252 using “ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252; or changing the character set to a UTF8 character set such as AL32UTF8

Startup Oracle database

SQL> startup mount;

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;

SQL> ALTER DATABASE OPEN;

If you not set your database with default schemas while installing then follow the next command.

SQL> update sys.props$ set VALUE$='WE8MSWIN1252' where NAME='NLS_CHARACTERSET';

SQL> commit;

SQL> shutdown immediate;

SQL> startup;

Know entry on tnsnames.ora file of Oracle form 6i which is located like this.

“C:/orant/NET80/ADMIN/tnsnames.ora”

Your entry should be like this.

ORCL =

   (DESCRIPTION =

      (ADDRESS_LIST =

            (ADDRESS =

              (PROTOCOL = TCP)

              (HOST = 127.0.0.1)

              (PORT = 1521)

             )

        )

      (CONNECT_DATA = (SID = orcl )

      )

   )