Question Re: Tp error in Technology Q&A

Tp error

Former Member — Thu, 01 Oct 2009 11:08:32 GMT

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

Re: Tp error

Former Member — Thu, 01 Oct 2009 12:28:22 GMT

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

Re: Tp error

Former Member — Thu, 01 Oct 2009 12:42:37 GMT

Dear Mohit,

Check the bold line @ above which i got when i check trans log.

Re: Tp error

markus_doehr2 — Thu, 01 Oct 2009 12:44:50 GMT

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

Did that work before? What did you change?

Markus

Re: Tp error

Former Member — Thu, 01 Oct 2009 12:52:08 GMT

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

Re: Tp error

markus_doehr2 — Thu, 01 Oct 2009 12:59:40 GMT

> 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

Re: Tp error

Former Member — Mon, 05 Oct 2009 04:00:12 GMT

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

Re: Tp error

Former Member — Mon, 05 Oct 2009 07:18:26 GMT

Dear Log file showing when i run R3trans -X

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0251444C) 22 82.922412

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02502BD8,srvhp=0251444C)

4 ETW000 36 82.922448

4 ETW000 [dev trc ,00000] Deallocating server context handle 0251444C 29 82.922477

4 ETW000 [dev trc ,00000] Allocating server context handle 31 82.922508

4 ETW000 [dev trc ,00000] Attaching to DB Server MRP (con_hdl=0,svchp=02502BD8,svrhp=0251444C)

4 ETW000 54 82.922562

4 ETW000 [dev trc ,00000] Mon Oct 05 12:13:00 2009 82085759 165.008321

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12518

4 ETW000 57 165.008378

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12518'

4 ETW000 53 165.008431

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12518 performing CON [dblink#5 @ 431]

4 ETW000 67232 165.075663

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12518: TNS:listener could not hand off client connection [dblink#5 @ 431]

4 ETW000 50 165.075713

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'MRP'"

Re: Tp error

former_member524429 — Mon, 05 Oct 2009 08:13:14 GMT

Dear Dik,

Try to do the following:

Restart the listener service.

-> open the command prompt as <sid>adm

sqlplus / as sysdba
shutdown immediate
startup

If you are receiving any errors during this activity, Please let us know with "R3trans -d" return code/trans.log.

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Oct 5, 2009 10:15 AM

Re: Tp error

Former Member — Mon, 05 Oct 2009 08:21:51 GMT

Hello,

unfortunatly, this is a pretty generic error. In the first step, I would verify the following points:

-> Do I have enough processes and sessions?

The result of the SQL statements

select count(*) from v$session

and

select count(*) from v$process

should not approach the limit you have set via the Oracle parameters SESSIONS and PROCESSES

-> Is there any secondary error reported that explains why the listener is not able so connect to a server process?

For this, locate the relevant entry in listener.log and post it to the thread.

Best Regards,

Michael

Re: Tp error

Former Member — Mon, 05 Oct 2009 09:22:29 GMT

Dear Bhavik,

Right now server is running but eroor remain same and end users working properly...

but if i tried

in running status then what will happen

SQLPLUS

system/manager as sysdba

SQL>Startup nomount

or SQL>shutdown immediate

as OS :-Windows2003

DB:- Oracle 10g

here two cases

First case :-Shold i try Above command when server is running.

is there any harmness when server is running

Secon case:- if i restart the server then can you tell me server will start

as error is related to database instance is not connecting.

please share your experince and guide me...

Regards

Dik

Re: Tp error

Former Member — Mon, 05 Oct 2009 09:26:44 GMT

Dear Michale,

thanks for reply

As i am having less knowledge oracle point of view.

according to you i will check process and sessions

through

sqlplus

system/manager as sysdba

SQL>select count(*) from v$session

and

SQL>select count(*) from v$process

then after what i have to do...

plese brief dear

Re: Tp error

Former Member — Mon, 05 Oct 2009 09:31:01 GMT

Hello,

just update the message with those 2 outputs, depending on this, we will see whether this is a problem or not.

Additionally, also execute the following 2 statements in sqlplus and provide the result:

 show parameter sessions

 show parameter processes

Best Regards,

Michael

Re: Tp error

Former Member — Mon, 05 Oct 2009 09:47:16 GMT

Dear i am getting error

when i am running

SQL>select count(*) from v$session

ORA -01012: not logged on.

while at tesing server i am getting result as 30 session.and 31 process.

Edited by: dik on Oct 5, 2009 11:49 AM

Re: Tp error

Former Member — Mon, 05 Oct 2009 10:00:37 GMT

Hello,

just to doublecheck:

Start a new sqlplus session and execute the failing statement again. If you are really already approaching your process limit, this could be a reason for the error (do not forget the output of the 'show parameter' statement mentioned above).

Best Regards,

Michael

Re: Tp error

Former Member — Mon, 05 Oct 2009 10:15:16 GMT

Dear I tried but every time it is showing same error ORA -01012: not logged on.

Re: Tp error

Former Member — Mon, 05 Oct 2009 10:20:24 GMT

Hello,

ok, in this case, just provide the values of SESSIONS and PROCESSES from the init<SID>.ora in %ORACLE_HOME%\database directory.

By the way, another possibility to execute those statements would be to use the DB connection the SAP system already has. You can execute the report RSORADJV via transaction SE38 in the SAP system. If you execute the statement there, does it work for you?

Best Regards,

Michael

Re: Tp error

Former Member — Mon, 05 Oct 2009 10:32:01 GMT

dear ,

This init.ora profile is a transparent copy of Oracle spfile. #

It was created by BRCONNECT at 2009-10-01 06.00.15. #
Please do not change this file! Maintain only the spfile. #
You can use BRSPACE for the altering of database parameters: #
brspace -f dbparam #

########################################################################

*._OPTIM_PEEK_USER_BINDS=FALSE

*.background_dump_dest='F:\oracle\MRP\saptrace\background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='G:\oracle\MRP\origlogA\cntrl\cntrlMRP.dbf','G:\oracle\MRP\origlogB\cntrl\cntrlMRP.dbf','G:\oracle\MRP\sapdata1\cntrl\cntrlMRP.dbf'

*.core_dump_dest='F:\oracle\MRP\saptrace\background'

*.db_block_size=8192

*.db_cache_size=281699942

*.db_files=254

*.db_name='MRP'

*.dml_locks=4000

*.event='10191 trace name context forever, level 1'

*.FILESYSTEMIO_OPTIONS='setall'

*.job_queue_processes=1

*.log_archive_dest='F:\oracle\MRP\oraarch\MRParch'

*.log_buffer=1048576

*.log_checkpoint_interval=0

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='10.2.0.1'

*.pga_aggregate_target=375599923

*.processes=80

*.recyclebin='off'

*.remote_login_passwordfile='exclusive'

*.remote_os_authent=true

*.sessions=96

*.sga_max_size=563399884

*.shared_pool_reserved_size=28169994

*.shared_pool_size=281699942

*.sort_area_retained_size=0

*.sort_area_size=2097152

*.statistics_level='typical'

*.undo_management='AUTO'

*.undo_retention=43200

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='F:\oracle\MRP\saptrace\usertrace'

*.workarea_size_policy='AUTO'

Re: Tp error

Former Member — Mon, 05 Oct 2009 10:50:34 GMT

Hello,

these are pretty much the standard values, however, we still do not know how many sessions / parameter are already consumed.

-> to be sure:

before executing the query

select count(*) from v$process

you were logging in to sqlplus via

sqlplus / as sysdba

, correct?

-> What is the result when you execute

select count(*) as result from v$process

and

select count(*) as result from v$session

via report RSORADJV as mentioned above?

Best Regards,

Michael

Re: Tp error

Former Member — Mon, 05 Oct 2009 11:00:16 GMT

Dear Thanks for instant support,

yes when i login as <sid>adm and run

sqlplus

system/database password as sysdba

(it shows only) connect

SQL>select count(*) from v$session;

then error

ORA _01012 :not logged on

while through program RSORADJV

when i executing select count(*) as result from v$process

it is showing 79

and select count(*) as result from v$session

it is showing 78

now tell me dear what should be the next approach to get....

Regards

Dik

Edited by: dik on Oct 5, 2009 1:02 PM

Edited by: dik on Oct 5, 2009 1:05 PM