Error running PREPARE at START OF PHASE TABSPC_PREP

[Former Member]

Hi,

Here I am again,

Running Prepare on a 46C > ECC6 and it stopped at this step…

>> 16:40:23 PREPARE: START OF PHASE TABSPC_PREP

determining table sizes ...

SAPup error message

SAPup> SEVERE ERROR: Execution of 'tp getdbobjsize' failed.

View file 'TP.ECO' and 'GDBSSHD.LOG'

in directory '/usr/sap/put/log' for details.

- "continue"

- "cancel"

Enter one of these options [continue] :=

Contents of FILE TP.ECO

BLOCKED SIGNALS: ''

SAPup> Starting subprocess 21698 at 20070615164042

ENV <0x9ffffffffffffb61>: ORACLE_PSRV=SID

ENV <0x9ffffffffffffdb0>: NLS_LANG=AMERICAN_AMERICA.WE8DEC

ENV <0x9ffffffffffffddd>: ORACLE_BASE=/oracle

ENV <0x9ffffffffffffe0a>: dbs_ora_tnsname=SID

ENV <0x9ffffffffffffe27>: ORACLE_SID=SID

ENV <0x600000000019c600>: DIR_LIBRARY=/usr/sap/put/exe

ENV <0x9ffffffffffffe83>: ORA_NLS10=/oracle/SID/102_64/nls/data

ENV <0x600000000018e590>: dbs_ora_schema=SAPR3

ENV <0x9ffffffffffffefd>: ORA_NLS33=/oracle/SID/920_64/ocommon/nls/admin/data

ENV <0x9fffffffffffff4f>: ORACLE_HOME=/oracle/SID/102_64

ENV <0x9fffffffffffff8e>: dbms_type=ORA

ENV <0x600000000019ca00>: LD_LIBRARY_PATH=/usr/sap/put/exe

ENV <0x600000000018e990>: auth_shadow_upgrade=0

EXECUTING /usr/sap/put/exe/tp (tp) pf=/usr/sap/put/bin/TABSPC.TPP getdbobjsize SID -x GDBSSHD.SIZ

This is /usr/sap/put/exe/tp version 305.13.23 (release 46D) for ANY database

Warning: unknown parameter WITH_TACOB in parameter file (line 19).

ERROR: : action is unknown

"GETDBOBJSIZE" unknown command: use "help" for an overview of possible commands

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0207

tp finished with return code: 207

meaning:

action is unknown

Process with ID 21698 terminated with status 207

Please assist me with this?

Thanks,

Iqbal

[markus_doehr2 · Accepted solution]

What do you see in GDBSSHD.LOG?

--

Markus

[Former Member · Accepted solution]

Funny, but that log does not exist.

Thanks,

Iqbal

[Former Member · Accepted solution]

Hi Markus, I tried restarting the entire prepare module and this is the error I am now getting…

>> 17:26:36 PREPARE: END OF PHASE CHK_DB6_PAR_INI

>> 17:26:36 PREPARE: START OF PHASE SPACECHK_INI

SAPup error message

SAPup> ERROR: No DB freespace check possible, code -4

>>> PLEASE READ THE HELP TEXT <<<

- "continue"

- "cancel"

Enter one of these options or "help" [continue] := help

>>> H E L P - T E X T <<<

An error occurred when the free space needed in the database

was compared with the free space currently available in the

database. The meaning of the return codes are:

-1: No input file found. Please reimport all data from CD-ROM.

-2: Unexpected fopen() error on SQL script file. Try to restart.

-3: Unexpected write error on SQL script file. Try to restart.

-4: Database tool not found. Call SAP Local Support.

-5: Unable to open SQL result file. Try to restart.

-6: Unable to open output result file. Try to restart.

-7: Unable to open temporary output file. Try to restart.

-8: Memory allocation error. Increase the virtual memory.

-9: Unable to evaluate the database container for singular

TABLE or INDEX requests. Call SAP Local Support.

-10: Error when calculating the sum of all free space requests.

Please call the SAP Local Support.

Can you please help me with this?

Thanks,

Iqbal

[markus_doehr2 · Accepted solution]

Seems to me, that you are missing brspace.. is it in your path?

--

Markus

[Former Member · Accepted solution]

Can you please assist me in setting it?

[Former Member · Accepted solution]

here is my path...

TEMP=/oracle/SID/tmp

THREAD=NOPS

ORACLE_PSRV=SID

SHLIB_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient:/lib

PATH=/bin:/usr/sap/SID/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/co

ntrib/kwdb/bin:/usr/bin/X11:/opt/graphics/common/bin:/opt/upgrade/bin:/usr/contrib/bin/X11:/opt/ipf/bin:/opt/resmon/bin:/opt/perf/bin:/opt/prm/bin:/opt/sec_mgmt/bas

tille/bin:/opt/gnome/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/sbin:/opt/mx/bin:/opt/sec_mgmt/spc/bin:/opt/ignite/bin:/opt/omni/bin:/opt/hpnpl//bin:/oracle/SID/102_6

4/bin

NLS_LANG=AMERICAN_AMERICA.WE8DEC

COLUMNS=164

ORACLE_BASE=/oracle

EDITOR=vi

LOGNAME=SIdadm

dbs_ora_tnsname=SID

ORACLE_SID=SID

ERASE=^H

PS1=$HOST:$LOGNAME $PWD $

HOST=hostname

DIR_LIBRARY=/usr/sap/SID/SYS/exe/run

DISPLAY=10.16.10.86:0.0

dbs_ora_schema=SAPR3

SHELL=/bin/sh

SAPDATA_HOME=/oracle/SID

ORA_NLS33=/oracle/SID/920_64/ocommon/nls/admin/data

HOME=/home/SIdadm

LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run

TERM=hpterm

ORACLE_HOME=/oracle/SID/102_64

PWD=/usr/sap/put/bin

TZ=PST8PDT

dbms_type=ORA

SAPSYSTEMNAME=SID

LINES=47

hostname:SIdadm /usr/sap/put/bin $

[markus_doehr2 · Accepted solution]

Can you execute brspace? Or any other brtool?

--

Markus

[Former Member · Accepted solution]

here is the output....

hostname:sidadm /home/sidadm $ brtools

BR155E No value found for option '-f'

BR377E BRTOOLS call failed

hostname:sidadm /home/sidadm $

thanks,

Iqbal

[markus_doehr2 · Accepted solution]

What do you get when you enter

brtools -V

(capital V)

--

Markus

[Former Member · Accepted solution]

hcgwdd3:hcpadm /home/hcpadm $ brtools -V

BRTOOLS 4.6D (13)

@(#) $Id: //bas/46D/src/ccm/rsbr/brtools.c#8 $ SAP

@(#) $Id: //bas/46D/src/ccm/rsbr/brxxsub.c#9 $ SAP

@(#) $Id: //bas/46D/src/ccm/rsbr/bruxsub.c#11 $ SAP

@(#) $Id: //bas/46D/src/ccm/rsbr/brntsub.c#10 $ SAP

Patch Date Note Text

4 2000-08-07 323324 Tablespace reorg hangs due to error in brtools

release note 321018

kernel release 46D

patch date 2001-03-01

patch level 13

make platform hp_64

make mode OCI_805_64

make date Mar 23 2001

[markus_doehr2 · Accepted solution]

Try to update your br*tools, they seem to be very old...

see Note 321018 - Corrections in BR programs Version 4.6D

--

Markus

[Former Member · Accepted solution]

okay thank you, will update the kernel, retry and advise.

thanks,

Iqbal

[Former Member · Accepted solution]

Quick question, where can I find the current Brtools for 46c?

Thanks,

Iqbal

[Former Member · Accepted solution]

Hi Iqbal,

have a look at OSS note 12741.

Depending on the Oracle version you use, you can use brtools 640 (Ora 9.2) or 700 (Ora 10).

This note also provides the path in SAP Service Marketplace where you can find the brtools package.

Best regard,

Elmar.

[markus_doehr2 · Accepted solution]

They are on the Service Marketplace if you have ordered extended maintenance for 4.6c...

--

Markus

[Former Member · Accepted solution]

After applying the new Brtools, I am still faced with the same issue…

Patch Date Note Text

100 2003-03-07 602497 BRRECOVER - new tool for restore and recovery

113 2003-08-08 649389 BR*Tools fail with BR167E when using Data Guard

release note 514205

kernel release 620

patch date 2005-03-10

patch level 135

make platform hpia64

make mode OCI_920_64

make date Aug 23 2005

I am stunted and will really appreciate your help…

Thanks,

Iqbal

[markus_doehr2 · Accepted solution]

So brtools is still giving "-f parameter missing"?

--

Markus

[Former Member · Accepted solution]

yep, i reverted back to the to one.

i was able to get pass this on the prepare before the oracle 10G upgrade.

any ideas?

thanks,

Iqbal

[markus_doehr2 · Accepted solution]

Hm... I have only one additional idea: You can try with the Br*tools for Oracle 9 (6.40 or the 7.00) because in those versions, "brtools" doesn't expect a parameter.

--

Markus

[Former Member · Accepted solution]

Just to add as an update to this thread, I was able to get pass this error with resetting the permission to the new data file that was added when I did the Oracle upgrade.

Thank you Markus and all that assisted me with this issue.

Iqbal