Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Tp error

Go to solution
Former Member

on ‎2009 Oct 01 12:08 PM

0 Likes
1,938

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

os--win2003

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 .

guide

Regards

Dik

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
markus_doehr2
Active Contributor
‎2009 Oct 01 1:44 PM
0 Likes

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

Did that work before? What did you change?

Markus

Show replies
Show replies
Former Member
‎2009 Oct 01 1:52 PM
0 Likes

Dear Sir,

Did not change any thing its giving eror suddenly....

i am totally surprise as i am thonking its is related to TNS adapter error...which means oracle connection breaks and R3trans -d giving 012 code.

is it...

then what can i do to resolve it...

regards

Dik

markus_doehr2
Active Contributor
‎2009 Oct 01 1:59 PM
0 Likes

> i am totally surprise as i am thonking its is related to TNS adapter error...which means oracle connection breaks and R3trans -d giving 012 code.

Is this 32bit?

Markus

Former Member
‎2009 Oct 05 5:00 AM
0 Likes

yes it is window 32 bit...

due to this online database back up is not completing ....

BR0051I BRBACKUP 7.00 (13)

BR0055I Start of database backup: bebpamhc.ant 2009-10-01 20.00.16

BR0280I BRBACKUP time stamp: 2009-10-01 20.00.17

BR0301E SQL error -20 at location BrDbConnect-2

ORA-00020: maximum number of processes (%s) exceeded

BR0310E Connect to database instance MRP failed

what should i do please help

regards

Dik

Ask a Question