EM 13.5c: Corrective Action (CA) ‘Add Space To Tablespace’ Fails With ‘ORA-15113: alias name 'DATAFILE' refers to a directory’
(Doc ID 2904605.1)
Last updated on APRIL 22, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Corrective Actions (CA) are used to specify automated responses to metric alerts. The corrective actions are associated with a target's metric thresholds. As soon as the metric’s threshold reaches the defined levels, the associated CA will be automatically executed. The CA ‘Add Space To Tablespace’ is used to add space automatically to tablespaces when the tablespace' usage reached the defined thresholds. But the CA ‘Add Space To Tablespace’ is failing to execute with below error stack.
*** BEGIN Parameters ***
Datafile Template: <Datafile Template>
Username: <User>
SID: <SID>
How to Increase Space: Increase by %
Minimum Free Space (MB): 100
Increase Tablespace Size (MB): 1024
Maximum Disk Usage (%): 90
Host: <Host>
Increase Bigfile Size (GB): 1
Maximum Tablespace Size (GB):
Protocol: TCP
Maximum Datafile Size (GB): 31
Port: 1521
Initial Datafile Size (MB): 1024
Autoextend: Yes
Autoextend Next Size (MB): 1024
How to Measure Free Space: % Full
Increase Bigfile Size (%): 5
Service name: <Service>
Role: normal
Maximum Bigfile Size (GB):
Increase Tablespace Size (%): 5
Tablespace: <Name>
*** END Parameters ***
Connector descriptor is (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<Service Name>(SERVER=DEDICATED)))
Tablespace type: PERMANENT
Bigfile tablepace: No
ASM disk group is: DGDATA1
Last created datafile: +DGDATA1/6FCB78124481E060E05351C4470AA0C4/DATAFILE/<Name>1110363925
Last created datafile size (MB): 28834
Tablespace total size (MB): 32767.984375
Largest numeric suffix: 0
Datafile filename: <Name>.348
Datafile directory: +DGDATA1/6FCB78124481E060E05351C4470AA0C4/DATAFILE/
Datafile suffix: .1110363925
ASM space usage for disk group DGDATA1 is free(MB): 488730.000, total(MB): 614395.000, required for mirroring(MB): 0.000, redundancy: 1
Maximum datafile size (GB): 31
Initial datafile size (MB): 1024
Next datafile size (MB): 1024
Last datafile size (MB) is: 28834
Last datafile max size (MB) is: 32767.984375
New datafile size (MB) is: 1638
New datafile max size (MB) is: 34406
Projected tablespace size (MB) is: 5571.984375
Projected tablespace max size (MB) is: 34406
ASM projected safely usable free space (MB) is: 487091.601
ASM projected Space Used (%) is: 20.72
Increasing size of datafile +DGDATA1/6FCB78124481E060E05351C4470AA0C4/DATAFILE/<Name>.348.1110363925 by 5 % of tablespace size
Resize datafile SQL is:
Template datafile specification is: +DGDATA1/6FCB78124481E060E05351C4470AA0C4/DATAFILE/
Add datafile SQL is: ALTER TABLESPACE “<Name>” ADD DATAFILE '+DGDATA1/6FCB78124481E060E05351C4470AA0C4/DATAFILE/' SIZE 1024M AUTOEXTEND ON MAXSIZE 1638M
Execute(ALTER TABLESPACE “<Name>” ADD DATAFILE '+DGDATA1/6FCB78124481E060E05351C4470AA0C4/DATAFILE/' SIZE 1024M AUTOEXTEND ON MAXSIZE 1638M) failed:ORA-15113: alias name 'DATAFILE' refers to a directory
ORA-15113: alias name 'DATAFILE' refers to a directory
ORA-15113: alias name 'DATAFILE' refers to a directory
ORA-15113: alias name 'DATAFILE' refers to a directory
ORA-15113: alias name 'DATAFILE' refers to a directory
ORA-15113: alias name 'DATAFILE' refers to a directory
ORA-15113: alias name 'DATAFILE' (DBD ERROR: OCIStmtExecute)
Disconnected from database
The same error can be seen in database alert log.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |