设置oracle连续出现问题
我目前正卷入一场关于oracle 10.2.0的安装和设置的意志之战。
我正在遵循本指南。在每一步都收到错误后,我终于读到了指南的最后,但在运行 catproc.sql 后却收到此错误消息:
PL/SQL procedure successfully completed.
Package body created.
No errors.
Package body created.
BEGIN
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13517
ORA-06512: at "SYS.DBMS_STATS", line 15859
ORA-06512: at "SYS.DBMS_STATS", line 15901
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_REGISTRY", line 560
ORA-06512: at "SYS.DBMS_REGISTRY", line 612
ORA-06512: at line 4
SQL>
为了达到此目的,我必须使用以下设置修改我的 init.ora 文件:
control_files = (C:\oracle\product\10.2.0\oradata\ora10\control01.ora,
C:\oracle\product\10.2.0\oradata\ora10\control02.ora,
C:\oracle\product\10.2.0\oradata\ora10\control03.ora)
undo_management = auto
db_name = ora10
db_block_size = 8192
db_cache_size=67108864
large_pool_size=1048576
shared_pool_size=117440512
我的“创建数据库”命令与 1 中列出的命令相同但我的数据文件是 C 而不是 D。
请记住,我不是 DBA,这些值只是从其他人在“网络”中遇到的各种问题中提取的。
I am currently embroiled in a battle of wills regarding the installation and setup of oracle 10.2.0.
I am following this guide. Having received errors at every step of the way I've finally got to the very end of the guide only to receive this error message after running catproc.sql:
PL/SQL procedure successfully completed.
Package body created.
No errors.
Package body created.
BEGIN
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13517
ORA-06512: at "SYS.DBMS_STATS", line 15859
ORA-06512: at "SYS.DBMS_STATS", line 15901
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_REGISTRY", line 560
ORA-06512: at "SYS.DBMS_REGISTRY", line 612
ORA-06512: at line 4
SQL>
To get this far I had to modify my init.ora file with the following settings:
control_files = (C:\oracle\product\10.2.0\oradata\ora10\control01.ora,
C:\oracle\product\10.2.0\oradata\ora10\control02.ora,
C:\oracle\product\10.2.0\oradata\ora10\control03.ora)
undo_management = auto
db_name = ora10
db_block_size = 8192
db_cache_size=67108864
large_pool_size=1048576
shared_pool_size=117440512
My 'create database' command is the same as listed at 1 but with my datafiles in C and not D.
And please remember I am not a DBA and these values are simply plucked from various problems others have had around the 'net.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我建议您使用 Oracle 数据库创建助手创建数据库 由于您缺乏Oracle数据库创建方面的知识。对于大多数情况来说这已经足够了。
您提供的链接中的问题是所有设置都非常低。由于数据文件太小,您迟早会看到有关
UNDO
段的其他问题。无论如何,这句话是这样说的:
它表示
TEMPFILE
表空间为 10MB,没有扩展。你可以尝试添加autoextend on
变成:或者因为你已经创建了表空间,你可以执行:
用这句话你在说:添加另一个临时文件到
TEMP
表空间大小为 10M(非常小!),并根据需要将其增大。从您的链接中,还要注意:
字符集WE8ISO8859P1
,我建议您使用UTF8
。db_cache_size
只有67MB,非常非常小。其他人也一样。无论如何,最好的开始方法是使用 Oracle 数据库创作助手。
I recommend you create the database with the Oracle Database Creation Assistant due to your lack of knowledge on Oracle database creation. It's good enough for most cases.
The problem in the link you provide is that ALL the settings are vey low. Sooner or later you'll see other problems regarding
UNDO
segment because of the little datafiles.Anyway, the sentence says:
It's saying that the
TEMPFILE
tablespace is 10MB with no extend. You can try to add theautoextend on
to become:Or because you have already created the tablespace you can execute:
With this sentence you are saying: add another tempfile to the
TEMP
tablespace with size 10M (very little!) and make it bigger as needed.From your link, also be careful with:
character set WE8ISO8859P1
, I recommend you to useUTF8
.logfile
s sizes can do the database very very slow they have to be bigger.db_cache_size
is only 67MB, very very little. The others too.Anyway, the best way to start is using the Oracle Database Creation Assistant.