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

SAP Managed Tags:
Windows Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Mohit,

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

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'"

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

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

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

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

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

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

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

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

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

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'

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

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

Hello,

ok, the error is pretty much clear now.

You have reached the limit that is imposed by the Oracle parameters PROCESSES and SESSIONS. Therefore, double both parameters, restart the DB and afterwards, check again whether R3trans and sqlplus are working as expected now.

Best Regards,

Michael

Dear Dik,

"ORA-01012: not logged on" ...

The problem is limit of parameter processes hit.

There's no much you can do, except drop some session, so that you can connect as sysdba and increase processes.

e.g.

to kill sessions..

alter system kill session 'session-id,session-serial'

to change parameters

alter system set PROCESSES=100 scope=SPFILE;
alter system set SESSIONS=115 scope=SPFILE;

Above are the examples. U can set them as per as your system capacity/load.

Regards,

Bhavik G. Shroff

it's about time you apply SAP note 830576 and adapt Oracle parameters accordingly.

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

Check your ORACLE_HOME Is correctly pointing to the right directory. then execute

command prompt> sqlplus / as sysdba

SQL> startup

Then try to execute previous sql commands as suggested and try starting SAP.

Dear,

Thanks for valuable support...

after increasing session and process i tried and now ok....

but can any one tell me the way through whic i can know which task will took how many session/process.

as i am having 15 user only and 10 dia wp and also file system and page memory sufficient.

so how can we know that process will exceeds for that particular task....

rectify me and guide me

thanks for everyone to valuable support....

Regards

Dik

Hello,

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,

Michael

dik, SAP note 830576 provides the formula to use for parameters sessions and processes.

Read this SAP note, it will explain everything.

Dear Sir,

i had seen that and all parameters ok.

but want to know basics behind them.

Answers (1)

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

Did that work before? What did you change?

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

> 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

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

Top Q&A Solution Author

User

Count

Tp error

Accepted Solutions (1)

Accepted Solutions (1)

Answers (1)

Answers (1)

Re: Re Generate Co files and data files

Re: error during install SAP S/4HANA Server 2022

Re: BODS Job Stored Procedure

Re: Query does not work in Procurement Price Speci...

Re: Integrate an external task system to Cloud ALM...