Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Renaming tablespace : error

Hi,

i have tried reorganize tables in tablespace PSAPBTABD in oracle 10, but in step 4 got error which can not resolve by myself:

I have done:

1.brspace -f tscreate -t PSAPNEWD -d both -l PSAPBTABD

2.brspace -f tbreorg -s PSAPBTABD -t "*" -n PSAPNEWD -p 6

3. brspace -f tsdrop -t PSAPBTABD

4. Renaming the new tablespace (sap must be done)

-


brspace -f tsalter -a rename -t PSAPNEWD -n PSAPBTABD

also have tried sqlplus

(alter tablespace PSAPNOVD rename to PSAPBTABD;).

In my opinion when i have execute stopsap i have started automaticly script stopdb and my DB now in strange condition. I have tryed shutdown immediate with sqlplus (getting error no logging) and brtools (see output below), i have tryed also to put tablespace PSAPBNOV to offline status but did not success (no logging message.

Pls help with step 4 (rename tablespavce) and startup DB.

Thanks a lot.

1 - Database close mode (mode) ...... [immediate]

2 - Force instance shutdown (force) . [yes]

3 - SQLPLUS command (command) ....... [shutdown immediate]

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

-


BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2007-10-27 08.42.44

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-10-27 08.42.44

BR0301W SQL error -1089 at location BrDbaConnect-2, SQL statement:

'CONNECT / IN SYSDBA MODE'

ORA-01089: immediate shutdown in progress - no operations are permitted

BR0310W Connect to database instance failed

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRSPACE time stamp: 2007-10-27 08.42.44

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

c

BR0280I BRSPACE time stamp: 2007-10-27 08.42.47

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0064I Database instance will be shut down now with mode 'immediate'

BR0280I BRSPACE time stamp: 2007-10-27 08.42.47

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

c

BR0280I BRSPACE time stamp: 2007-10-27 08.42.52

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-10-27 08.42.52

BR0307I Shutting down database instance ...

BR0278E Command output of '/oracle/SID/1020_64/bin/sqlplus':

SQL*Plus: Release 10.2.0.3.0 - Production on Sat Oct 27 08:42:52 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> Connected to an idle instance.

SQL>

SQL> ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

SQL> Disconnected

BR0280I BRSPACE time stamp: 2007-10-27 08.42.54

BR0279E Return code from '/oracle/SID/1020_64/bin/sqlplus': 0

BR0302E SQLPLUS call for database instance failed

BR0309E Shutdown of database instance failed

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question