Re: Creating Oracle Repository/Designer 9.0.2 to Oracle 8i ee

From: GoranV <gorle_at_freemail.com.mk>
Date: Mon, 02 Jun 2003 11:37:31 +0200
Message-ID: <5f6mdvg06ik6ibb741jt7muvm6l092ut4t@4ax.com>

Vo <dbqkdv0l67jep32qu6r8l0l3f2dgjim14f_at_4ax.com> Sybrand Bakker wrote:

|
| Either you didn't run the script for the 9i export views, for the
| latest version always called $ORACLE_HOME/rdbms/admin/catexp.sql
| or (more likely) you didn't create the Oracle 8 export views. The
| script probably is called catexp8.sql and should be run as internal.

I try to connect as internal
connect / as sysdba (sysoper)
but i got error like
ERROR:
ORA-12203: TNS:unable to connect to destination

Warning: You are no longer connected to ORACLE.

the sqlnet.log file is:

---

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora9iDS\BIN\SQLPLUS.EXE)(HOST=GORLE)(USER=Gorle))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 9.0.1.3.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version

9.0.1.3.0 - Production
  Time: 02-JUN-2003 11:20:15
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 2
    nt OS err code: 0

---

Any solution?

| Please note also you can't import 9i exports in 8i. You should create
| an 8i export.
|
|
| Sybrand Bakker, Senior Oracle DBA
|
| To reply remove -verwijderdit from my e-mail address

Gorle Received on Mon Jun 02 2003 - 04:37:31 CDT