ora - 27092

[Roshan]

Hello Erman,

Happy New Year 2017

27092.png

I checked the ulimit, it is unlimited. The data file is not listed in dba_data_files.

Can you please advise

Regards,
Roshan

[ErmanArslansOracleBlog]

Check this note:

ORA-27092 if ULIMIT Small on Client OS User (Doc ID 165282.1)

do the actions documented in note.

If the issue persists, send me the output of ulimit -a executed by the "oracle" OS user.
you probably could not set the ulimit properly for the oracle OS user.

[ErmanArslansOracleBlog]

Also send me your OS vendor and OS version.

[Roshan]

archicom@CSISCC3 : /archicom/sgbd $ oslevel -g
Fileset                                 Actual Level        Maintenance Level
-----------------------------------------------------------------------------
bos.rte                                 5.3.7.0             5.3.0.0


I did
archicom@CSISCC3 : /archicom/sgbd $ ls -ltr dfileARCHICOM.dbf
-rw-r-----   1 oracle   dba      2145394688 05 jan 11:30 dfileARCHICOM.dbf

when the user logged in as oracle user and executed the script, it executed successfully. The ulimit was unlimited.

Why when he executed the script as archicom user the script executed?

Regards,
Roshan

[ErmanArslansOracleBlog]

ulimits for archicom user is not defined properly then...

[ErmanArslansOracleBlog]

The following should be your limits (minimum) on AIX..

Shell limits

Soft File Descriptors        at least 1024 KB
Hard File Descriptors        at least 65536 KB
Number of processes (Soft)    at least 2047
Number of processes (Hard)    at least 16384
Soft STACK size                at least 10240 KB
Hard STACK size                at least 10240 KB; at most 32768 KB
Soft FILE size                unlimited
Soft CPU time                unlimited
Note: This is the default value.

Soft DATA segment            unlimited
Soft Real Memory size        unlimited

maxuprocs    16384
ncargs        128

[ErmanArslansOracleBlog]

For AIX, it is the ulimit settings that determine process memory related resource limits , you can set either by using the smit utility or by editing the /etc/security/limits file...

So, set those limits for archicom OS user.

[Roshan]

Thanks Erman. I will change it.