Unable to load to oracle tablespaces

[jsquizz]

Hi all,

Fresh oracle DB running 19c (i think..) and CMOD 10.5.

Trying to load using tablespaces,

2021-01-29 02:11:00.050814: ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsload.c, Line=6736

2021-01-29 02:11:00.050851: ARS1158E Failed while attempting to load the database

2021-01-29 02:11:00.311342: ARS1146I Loaded 0 rows into the database

2021-01-29 02:11:00.311378: ARS4311E Loading failed

2021-01-29 02:11:00.311398: ARS4320I Unloading started

Within the system log -

Unable to find SMS tablespace filesystems.  Either the defined SMS filesystems are full or there are no SMS filesystems defined.


these are defined within ars.dbfs-


#‌ Filesystem                        Tablespace Type (SMS)

#‌ --------------------------------------------------------------

‌/u02/oracle/oradata/fs02/archive     SMS

that specified directory exists

/u02/oracle/oradata/fs02/archive: directory

We can manually create a tablespace within above filesystem outside of CMOD, but it wont work for us when we load.

Anyone have suggestions?

[Justin Derrick]

Check directory permissions?  Can the id is running the CMOD's arssockd create it?  Databases can be picky about root if you're running CMOD as root.  Also check group memberships as well if you're granting authority that way.  Otherwise, ping your Oracle DBA's to check logs relating to the tablespace creation.

-JD.

[jsquizz]

yeah, Can do all that. CMOD is running as "archive" user -> can create table spaces, touch a file in the directory, etc. I will look into group membership though