Error using BRTOOLS

[Former Member]

Hi all,

I am trying to use BRTOOLS (in Linux) for extending the tablespace but facing a few issues with it. In fact, I am facing the issues while trying to use any of the menu options that come up. I have pasted a log which has the details of the inputs given while trying to view the tablespace using brtools:

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.05

BR0656I Choice menu 1 - please make a selection

-

---

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.09

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.09

BR0656I Choice menu 5 - please make a selection

-

---

Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

7

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.13

BR0663I Your choice: '7'

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.13

BR0656I Choice menu 6 - please make a selection

-

---

Additional database space functions

1 = Show tablespaces

2 - Show data files

3 - Show redolog files

4 - Show control files

5 - Show disk volumes

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.24

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.24

BR0657I Input menu 75 - please check/enter input values

-

---

BRSPACE options for showing database information

1 - BRSPACE profile (profile) ........ [initOPP.sap]

2 - Database user/password (user) .... [/]

3 # Database instance (instance) ..... []

4 # Database parameter (parameter) ... []

5 ~ Database tablespace (tablespace) . []

6 # Database file (file) ............. []

7 # Database owner (owner) ........... []

8 # Database table (table) ........... []

9 # Database index (index) ........... []

10 - Create log file (log) ............ [no]

11 - Confirmation mode (confirm) ...... [yes]

12 # Extended output (output) ......... [no]

13 - Scrolling line count (scroll) .... [20]

14 - Message language (language) ...... [E]

15 - BRSPACE command line (command) ... [-p initOPP.sap -s 20 -l E -f dbshow -c tsinfo]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.33

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initOPP.sap -s 20 -l E -f dbshow -c tsinfo'

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.33

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.50

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

*BR0252E Function fopen() failed for '/oracle/OPP/102_32/sapbackup/.user.pas' at location BrToolCall-2

BR0253E errno 2: No such file or directory*

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRTOOLS time stamp: 2010-08-30 03.44.50

Can somebody please advice me on what could be going wrong here?

Thanks,

Mudit

[former_member204746 · Accepted solution]

user permissions problem

try these commands:

chmod 775 /oracle/OPP/102_32/sapbackup

chown oraopp:dba /oracle/OPP/102_32/sapbackup

chmod 775 /oracle/OPP/102_32

chown oraopp:dba /oracle/OPP/102_32

chmod 775 /oracle/OPP/

chown oraopp:dba /oracle/OPP

chmod 775 /oracle

chown oraopp:dba /oracle

This should do the trick.

[Former Member]

Hi Mudit,

PLease do a sudo to ora<sid> before executing brtools.

your problem will be resolved.

command is :

sudo su - ora<sid>.

Please let me know if your prob is resolved.

Regards,

Deepa.

[Former Member]

Hi

Check for space, hope permission should solve your problem.

Regards,

Deepanshu

[sunny_pahuja2]

Hi,

> BR0280I BRTOOLS time stamp: 2010-08-30 03.44.50

> BR0257I Your reply: 'c'

> BR0259I Program execution will be continued...

> *BR0252E Function fopen() failed for '/oracle/OPP/102_32/sapbackup/.user.pas' at location BrToolCall-2

> BR0253E errno 2: No such file or directory*

Check above error, user is not able to open the above directory.

Thanks

Sunny