ORA-28511: lost RPC connection to heterogeneous remote agent using

ERROR at line 1: ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora)(PORT=1522))(CONNECT_DATA =(SID=IT_D))) ORA-02063: preceding line from TDR Process ID: 10881 Session ID: 225 Serial number: 381 Follow:- Unable To Connect To Teradata DB Using Oracle 11g or 12c Database Gateway For Teradata (Continue reading “ORA-28511: lost RPC connection to heterogeneous remote agent using”

Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 -STEP1

Originally posted on SAFI:
Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 STEP 1. Install Teradata Client for Linux x86-64 [oracle@oratest1 tdclient]$ ls -lrt total 57196 -rwxr-xr-x 1 root root    86989 Sep 18 10:45 npaxsmod1400-14.00.00.04-1.noarch.rpm -rwxr-xr-x 1 root root 20757442 Sep 18 10:45 tdodbc-14.00.00.04-1.noarch.rpm -rwxr-xr-x 1 root root  3005122 Sep…

Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 -STEP III

Once the installation is done of the TD client and Oracle Gateway Software additonal configuration needs to be made. Change directory to the oracle gateway home. [oracle@oratest1 admin]$ pwd /u01/app/oracle/product/11.2.0.4/TD/dg4tera/admin Copy initdg4tera.ora to init<TD_SID>.ora and make changes to the listener.ora file and add the tns entry to the tnsnames.ora file of the Oracle Database home.Continue reading “Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 -STEP III”

Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 -STEP2

Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 – STEP II Install Oracle Gateway Software After the installation of TD client. Go to /etc/profile to find the correct path of the Teradata Libraries

Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 -STEP1

Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 STEP 1. Install Teradata Client for Linux x86-64 [oracle@oratest1 tdclient]$ ls -lrt total 57196 -rwxr-xr-x 1 root root    86989 Sep 18 10:45 npaxsmod1400-14.00.00.04-1.noarch.rpm -rwxr-xr-x 1 root root 20757442 Sep 18 10:45 tdodbc-14.00.00.04-1.noarch.rpm -rwxr-xr-x 1 root root  3005122 Sep 18 10:46 tdwallet1400-14.00.00.06-1.noarch.rpm -rwxr-xr-xContinue reading “Oracle Database Gateway Installation on Linux x86-64 bit to connect to Teradata 14 -STEP1”

DROPPING REPOSITORY FOR EMC Cloud Control 12c installation

DROPPING REPOSITORY FOR EMC Cloud Control 12c installationoracle@cloud1 dbhome_1]$ echo $ORACLE_SIDTEST[oracle@cloud1 dbhome_1]$ emca -deconfig dbcontrol db -repos drop -SYS_PWD sys -SYSMAN_PWD sysman STARTED EMCA at May 6, 2014 8:23:13 AMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved. Enter the following information:Database SID: TESTListener port number: 1521 ———————————————————————-WARNING : While repositoryContinue reading “DROPPING REPOSITORY FOR EMC Cloud Control 12c installation”

ORA-00604: error occurred at recursive SQL level 1 + ORA-02429

SQL> drop tablespace FMC_HRMS_DTS including contents and datafiles; drop tablespace FMC_HRMS_DTS including contents and datafiles * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-02429: cannot drop index used for enforcement of unique/primary key  STEP 1:-SQL> select owner, constraint_name,table_name,index_owner,index_name from dba_constraints where (index_owner,index_name) in (select owner, index_name from dba_indexes where tablespace_nameContinue reading “ORA-00604: error occurred at recursive SQL level 1 + ORA-02429”

Design a site like this with WordPress.com
Get started