设置完了,应该重启server。下面是几种可能的出错原因:ORA-1308: initialization parameter UTL_FILE_DIR is not set. ORA-1336 - this error is returned under the following conditions: 1. Dictionary_location does not exist. 2. UTL_FILE_DIR is not set to have access to dictionary_location. 3. Dictionary file is read only.
G:\oracle\product\10.1.0\admin\orcl 这个文件路径是存在的。但不知Dictionary file is read only在哪设置?
windows下资源管理器提前设置好了,不就可以了
我执行下面操作的结果: SQL> show parameter utl;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ create_stored_outlines string utl_file_dir string 但我在init.ora中已经设置了这个参数: utl_file_dir=G:\oracle\product\10.1.0\admin\orcl 打开也能看到这个参数,询问原因
我在第一步已经设置了这个参数了》
ORA-1336 - this error is returned under the following conditions:
1. Dictionary_location does not exist.
2. UTL_FILE_DIR is not set to have access to dictionary_location.
3. Dictionary file is read only.
SQL> show parameter utl;NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string
但我在init.ora中已经设置了这个参数:
utl_file_dir=G:\oracle\product\10.1.0\admin\orcl
打开也能看到这个参数,询问原因