• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1059
  • Last Modified:

Oracle Database Link Error

Hi there,
I was wondering if you can help me out here...
I'm trying to create a database link from the Oracle db (10.2g) to a DB2/AS400...
So far, I created an Database Gateway for DRDB 11.2.0.1.0 connection.
Then I edited the tnsnames.ora, listener.ora and initsvdatpv51.ora files following below:
initsvdatpv51.ora:
[oracle@dbctuat admin]$ pwd
/u01/app/oracle/11.2/gw11/dg4db2/admin
[oracle@dbctuat admin]$ vi initsvdatpv51.ora
HS_FDS_CONNECT_INFO=[10.0.1.1]:446/S65A6BE2,IOS
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_TRANSACTION_MODEL=COMMIT_CONFIRM
HS_FDS_TRANSACTION_ISOLATION=READ_COMMITTED
HS_FDS_SUPPORT_STATISTICS=TRUE
HS_FDS_RESULTSET_SUPPORT=FALSE
HS_FDS_PACKAGE_COLLID=SVDATPV51 #Library of core db
HS_IDLE_TIMEOUT=0
listener.ora
[oracle@dbctuat admin]$ pwd
/u01/app/oracle/11.2/gw11/network/admin
[oracle@dbctuat admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/11.2/gw11/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbctuat)(PORT = 1522))
    )
  )

SID_LIST_LISTENER_GW=
        (SID_DESC=
        (SID_NAME=svdatpv51)
        (ORACLE_HOME=/u01/app/oracle/11.2/gw11)
        (PROGRAM=dg4db2)
        )
#ADR_BASE_LISTENER = /u01/app/oracle

tnsnames.ora
[oracle@dbctuat admin]$ pwd
/u01/app/oracle/10.2/db_1/network/admin
[oracle@dbctuat admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/10.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MSBCRM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dbctuat)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MSBCRM)
    )
  )

SVDATPV51=
  (DESCRIPTION=
   (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.1)(PORT=1522))
   (CONNECT_DATA=(SID=svdatpv51))
   (HS=OK)
   )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Within SQLPLUS, I created a database link:
create public database link dblink_svdatpv51 connect to "USER" identified by "password" using 'SVDATPV51';

When I want to test it out: select * from dual@svdatpv51;;

I get an error:

Error at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from DBLINK_SVDATPV51

What am I missing?

Thanks for your help, and please let me know if you need additional info...

Much appreciated,
0
dinhchung82
Asked:
dinhchung82
  • 2
1 Solution
 
Javier MoralesOracle DBACommented:
It's a DB2 issue due to conversion from a CCSID 65535 code page to 37 (ms standard and Oracle)
you whould have to set up the driver to allow that kind of conversion and retry.

If it's ODBC, Go to ODBC in control panel and click configure button, there's an option to convert from AS/400. Then click the translation tab... There you will find a translate CCSID 65535 radio button (click it).

Not a mainly oracle issue...
0
 
dinhchung82Author Commented:
Dear All, I have solved problem. This error ORA-28545 and ORA-02063 relate to tns or listener. I have done as below:

tnsnames.ora
[oracle@dbctuat admin]$ pwd
/u01/app/oracle/10.2/db_1/network/admin
[oracle@dbctuat admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/10.2/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MSBCRM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dbctuat)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MSBCRM)
    )
  )

SVDATPV51=
  (DESCRIPTION=
   (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.1.1)(PORT=1522))
   (CONNECT_DATA=(SID=svdatpv51))
   (HS=OK)
   )

[oracle@dbctuat admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/10.2/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc,msbcrm)
      (ORACLE_HOME = /u01/app/oracle/10.2/db_1)
      (PROGRAM = extproc)
    )
)
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbctuat)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
ADR_BASE_LISTENER = /u01/app/oracle

[oracle@dbctuat admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/11.2/gw11/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER_GW =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbctuat)(PORT = 1522))
    )
  )

SID_LIST_LISTENER_GW=
(SID_DESC=
        (SID_NAME=su1ebsdat)
        (ORACLE_HOME=/u01/app/oracle/11.2/gw11)
        (PROGRAM=dg4db2)
        )
Thanks all support
0
 
dinhchung82Author Commented:
i try to fix it by tns and listener , it is okie
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now