BRTools giving BR0622E Database SID is not open

[former_member339060]

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

[Jiajia]

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

[JamesZ]

Hi Pavan,

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

Best regards,
James

[Former Member]

What is the user id you are using ?

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

Regards,

Harish Karra

[Reagan]

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.