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”
Author Archives: SAFI
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 -STEP2.
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 installation.
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
ORA-00604: error occurred at recursive SQL level 1 + ORA-02429.
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”