I have a stored procedure in Oracle 10G. This procedure will read from a table and create a fixed width flat file by using the: UTL_File.put_line command.
The DBA set up entries in init.ora file to
Include a parameter for utl_file_dir for each directory we want to make accessible for UTL_FILE operations.
This all works in the test environment. When we went to production no file is ever created. I believe that the init.ora file is set up correctly in production. The DIFFERENCE between test and production environment is the test database is within the domain and the production database is within it's own workgroup outside the domain. Therefore, thinking that the server that the file is to be written to, does not know who Oracle is, if that makes sense, and won't allow the file to be written.
If anyone has any ideas as to a fix or workaround, that would be great!
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.