OnDemand User Group
Support Forums => MP Server => Topic started by: jsquizz on February 04, 2021, 06:33:01 PM
-
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?
-
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.
-
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