Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Tp error

Dear All,

here i am facing tp error 232 at our production server.

up to now every thing is working fine but when i started import at production side then i got tp connection failed with 0232 code.

i run retrans -d then i found 012 return code and when i check loog file then i found

CLIENT_ORACLE_HOME is not set as environment variable or

DIR_CLIENT_ORAHOME is not set as profile parameter.

assuming using instant client with unspecified location.

ERROR => OCI-call 'OCIServerAttach' failed: rc = 12518

ERROR => CONNECT failed with sql error '12518

above error is regarding connection break with database if i am correct then which is related to listner problem.

TNS-12564: TNS:connection refused

so that R3trans -d giving 012 return code.

please suggest me what should i can do ....


dbs---oracle 10g

as i am thinking it can be resolve after setting some parametre @ environment variable

or else restarting server at OS level with TNS --lisnter service .




Former Member
Former Member replied


you can use the following SQL statements which show the relationsship between client processes and sessions and between sessions and processes:

This statement shows how man sessions belong to the different client processes

select program, process, count(*)
from v$session
group by program, process
order by 3;

Please note in case of windows, the process id of the client processes is shown in a format like 3696:2640. The first number (here 3696) would be the actual pid of the process that you can look up for example via the task manager.

When you want to see the number of processes that belong to different sessions (this could become handy in case of parallel query), you can execute the following statement:

select s.sid, s.program, count(*) from
V$session s, v$process p
where s.paddr = p.addr
group by s.sid, s.program
order by 3;

Best Regards,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question