Skip to Content
0
Former Member
Oct 27, 2007 at 07:19 AM

Renaming tablespace : error

74 Views

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