ORA-12533: TNS:illegal ADDRESS parameters
Answer / guest
Cause: An illegal set of protocol adapter parameters was
specified. In some cases, this error is returned when a
connection cannot be made to the protocol transport.
Action: Verify that the destination can be reached using the
specified protocol. Check the parameters within the ADDRESS
section of TNSNAMES.ORA. Legal ADDRESS parameter formats may
be found in the Oracle operating system specific
documentation for your platform. Protocols that resolve
names at the transport layer (such as DECnet object names)
are vulnerable to this error if not properly configured or
names are misspelled.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-22916: cannot do an exact FETCH on a query with Nested cursors
SQL*Loader-00931: OCI error while binding variable for column string in table string
LFI-00144: File [string][string] does not exist
RMAN-06727: could not locate datafilecopy string
CLSR-01004: Failed to mount database
RMAN-06541: tablespace string will be included in future whole database backups
RMAN-06432: recovery catalog dropped
RMAN-08510: archive log thread=string sequence=string
TNS-01078: Opened name lookup file: string
ORA-39053: parameter or attribute string must be defined for a string job
UDE-00011: parameter string is incompatible with parameter string
Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...