英文:
ORA-12609: tns: receive timeout occurred- Error Occurs When Running Query to Create Tablespace
问题
有人可以帮忙吗?我生成了一个脚本来从Oracle 12c(ASM)创建一个表空间,然后在19c(也是ASM)上运行它。但是,出现了一个错误ORA-12609:tns:接收超时。
请帮忙。谢谢。
我尝试在sqlnet.ora中设置以下参数:
SQLNET.INBOUND_CONNECT_TIMEOUT=3600
SQLNET.RECV_TIMEOUT=3600
SQLNET.SEND_TIMEOUT=3600
然而,完全不起作用,20秒后仍然出现上述错误。
以下是警报日志。
2023-02-27T13:57:58.662314+07:00
ORA-1013在以下时刻发生:CREATE TABLESPACE ARCH DATAFILE
'+DATA' 大小为11400M,自动扩展,下一个100M,最大大小不限
日志记录
默认
不使用内存
在线
区管理本地,自动分配
块大小8K
段空间管理自动
FLASHBACK 打开...
2023-02-27T13:59:01.455679+07:00
注意:使用默认的ASM根目录ASM
注意:使用默认的ASM根目录ASM
注意:使用默认的ASM根目录ASM
注意:使用默认的ASM根目录ASM
英文:
Could any one help? I generate a script to create a tablespace from Oracle 12c (ASM), then run it into 19c (ASM as well). However, there is an error occurs ORA-12609: tns: receive timeout occurred.
CREATE TABLESPACE ARCH DATAFILE
'+DATA' SIZE 11400M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
DEFAULT
NO INMEMORY
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
Please help. Thanks.
I try to set the parameters in sqlnet.ora as below:
SQLNET.INBOUND_CONNECT_TIMEOUT=3600
SQLNET.RECV_TIMEOUT=3600
SQLNET.SEND_TIMEOUT=3600
However, it does not work at all, the mentioned error keeps appearing after 20 secs.
Here is the alert logs.
2023-02-27T13:57:58.662314+07:00
ORA-1013 signalled during: CREATE TABLESPACE ARCH DATAFILE
'+DATA' SIZE 11400M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
DEFAULT
NO INMEMORY
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON...
2023-02-27T13:59:01.455679+07:00
NOTE: Using default ASM root directory ASM
NOTE: Using default ASM root directory ASM
NOTE: Using default ASM root directory ASM
NOTE: Using default ASM root directory ASM
答案1
得分: 1
我解决了这个问题。那个错误是由于不正确的SQL格式引起的。
谢谢你的帮助!
英文:
I resolved the issue. That error due to bad SQL format.
Thank you for your help!
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论