Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 01, 2009 at 12:28 PM
    R3trans -d giving 012 return code.

    Seems your connection to DB is not working.Please check trans.log for more details & paste it to assist you further.

    Thanks..

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 01, 2009 at 12:44 PM

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

    Did that work before? What did you change?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Markus Doehr

      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