Skip to Content

BRTools giving BR0622E Database SID is not open

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 15, 2016 at 09:17 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 07:08 PM

    What is the user id you are using ?

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

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2016 at 07:52 AM

    Hi Pavan,

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

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded