ORA-29339: tablespace block size 32768 does not match configured block sizes

admin

1.创建非标准块得表空间失败

1. 
   
2. SQL> select name from v$datafile;
   
3. 
   
4. NAME
   
5. --------------------------------------------------------------------------------
   
6. /app/oracle/db/oradata/ORA19/system01.dbf
   
7. /app/oracle/db/oradata/ORA19/sysaux01.dbf
   
8. /app/oracle/db/oradata/ORA19/undotbs01.dbf
   
9. /app/oracle/db/oradata/ORA19/users01.dbf
   
10. 
    
11. SQL> create tablespace zhyu datafile '/app/oracle/db/oradata/ORA19/zhyu01.dbf' size 50m LOGGING ONLINE PERMANENT BLOCKSIZE 32768;
    
12. create tablespace zhyu datafile '/app/oracle/db/oradata/ORA19/zhyu01.dbf' size 50m LOGGING ONLINE PERMANENT BLOCKSIZE 32768
    
13. *
    
14. ERROR at line 1:
    
15. ORA-29339: tablespace block size 32768 does not match configured block sizes
    
16. 
    
17. 
    
18. SQL> create tablespace zhyu datafile '/app/oracle/db/oradata/ORA19/zhyu01.dbf' size 50m BLOCKSIZE 32768;
    
19. create tablespace zhyu datafile '/app/oracle/db/oradata/ORA19/zhyu01.dbf' size 50m BLOCKSIZE 32768
    
20. *
    
21. ERROR at line 1:
    
22. ORA-29339: tablespace block size 32768 does not match configured block sizes

复制代码

2.修改次相关得参数

1. SQL> alter system set db_32k_cache_size=3g scope=spfile;
   
2. 
   
3. System altered.
   
4. 
   
5. SQL> shutdown immediate

复制代码

3.再次启动，创建成功

1. 
   
2. SQL> create spfile from pfile='/app/oracle/db/19.3.0/home1/dbs/pfileora19.ora';
   
3. 
   
4. File created.
   
5. 
   
6. SQL> startup
   
7. ORACLE instance started.
   
8. 
   
9. Total System Global Area 4294963272 bytes
   
10. Fixed Size                  8904776 bytes
    
11. Variable Size             369098752 bytes
    
12. Database Buffers         3909091328 bytes
    
13. Redo Buffers                7868416 bytes
    
14. Database mounted.
    
15. Database opened.
    
16. SQL> show parameter db_32k
    
17. 
    
18. NAME                                 TYPE        VALUE
    
19. ------------------------------------ ----------- ------------------------------
    
20. db_32k_cache_size                    big integer 3G
    
21. SQL> create tablespace zhyu datafile '/app/oracle/db/oradata/ORA19/zhyu01.dbf' size 50m BLOCKSIZE 32768;
    
22. 
    
23. Tablespace created.

复制代码