Couldn't create temprary datafiles
ALTER TABLESPACE TEMP1 ADD TEMPFILE '/u02/QA/db/apps_st/data/temp01.dbf' SIZE 3000M REUSE AUTOEXTEND OFF;
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.NAME_SECURITY", line 166
ORA-06512: at line 2
I did find the following warning message in alert log. Are they related?
WARNING:Oracle instance running on a system with low open file descriptor
limit. Tune your system to increase this limit to avoid