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 ....
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 .
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;