ORA-12609: tns: receive timeout occurred- Error Occurs When Running Query to Create Tablespace

Question

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

Please edit that into the question as formatted/readable text, not as comments. — Alex Poole, Feb 27 '23 at 09:13
@AlexPoole I have edited the question, adding alert logs. Thank you for your help! — Hung Tran, Feb 28 '23 at 01:36

score 1 · Answer 1 · answered Feb 28 '23 at 06:36

1

I resolved the issue. That error due to bad SQL format.

Thank you for your help!

answered Feb 28 '23 at 06:36

Hung Tran

21
4

ORA-12609: tns: receive timeout occurred- Error Occurs When Running Query to Create Tablespace

1 Answers1