Skip to Content
0

BRTools giving BR0622E Database SID is not open

Oct 15, 2016 at 07:35 PM

195

avatar image

Hi Team,

Can anyone please help me here. I am trying to create the table space but BRTOOLS is giving database sid is not open. But when I check the oracle db status by select v$instance it is open.

Can any one please suggest. I have created a spfile and restarted the system in normal passion ( I mean by sqlplus ) startup.

BR0280I BRTOOLS time stamp: 2016-10-14 21:32:39
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
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2016-10-14 21:32:40
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2016-10-14 21:32:40
BR0657I Input menu 82 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for create tablespace

1 - BRSPACE profile (profile) ...... [initSID.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... []
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initSID.sap -s 20 -l E -f tscreate]

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2016-10-14 21:32:42
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initSID.sap -s 20 -l E -f tscreate'

BR0280I BRTOOLS time stamp: 2016-10-14 21:32:42
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2016-10-14 21:32:43
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.40 (12)
BR1002I Start of BRSPACE processing: seugzhvf.tsc 2016-10-14 21:32:43
BR0484I BRSPACE log file: /oracle/SID/sapreorg/seugzhvf.tsc

BR0622E Database SID is not open

BR0700E Fatal errors occurred - terminating processing...

BR1008I End of BRSPACE processing: seugzhvf.tsc 2016-10-14 21:32:44
BR0280I BRSPACE time stamp: 2016-10-14 21:32:44
BR1007I BRSPACE terminated with errors

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

BR0292I Execution of BRSPACE finished with return code 3

BR0280I BRTOOLS time stamp: 2016-10-14 21:32:44
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

Really appricaite your help.

Thanks

Pavan P

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Reagan Benjamin
Oct 15, 2016 at 09:17 PM
0

If you are trying to create a tablespace then why are you not specifying the tablespace name under the "BRSPACE options for create tablespace"? You left the option 3 "3 ~ Tablespace name (tablespace) ... []" blank and continued.

Share
10 |10000 characters needed characters left characters exceeded
Harish Karra Oct 20, 2016 at 07:08 PM
0

What is the user id you are using ?

Check 113747 and fix permissions to BRTOOLs & Update BRtools with latest available version.

Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded
James Zhang
Oct 21, 2016 at 07:52 AM
0

Hi Pavan,

Check whether you are starting brtools with correct user and whether oracle_sid environment variable is correctly set.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
Jiajia Zhang
Oct 25, 2016 at 06:13 AM
0

Hello Pavan,

If you are using Cluster, please confirm that you log in on the cluster node which is hosting the DB and run the brtools.

Best regards,

Jiajia

Share
10 |10000 characters needed characters left characters exceeded