export ORACLE_SID=EPCOLL
[oracle@S85-A]/oracle/product/10g/dbs>sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.3.0 - Production on Wed Mar 18 09:33:16 2009Copyright (c) 1982, 2006, Oracle. All Rights Reserved.ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
Enter user-name:
[oracle@S85-A]/oracle/product/10g/dbs>sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.3.0 - Production on Wed Mar 18 09:33:16 2009Copyright (c) 1982, 2006, Oracle. All Rights Reserved.ERROR:
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 9925
Enter user-name:
解决方案 »
- 用SQL语句如何将以设置为可以为“空”的字段改为“空”
- 关于Oracle远程存储的问题,各位大虾麻烦多多指点一下吧
- sql列转行(在线等)
- 高人帮忙看个牛的存贮过程更新出现错误问题!!!!!
- oracle 9i 群集问题,两台服务器+磁盘阵列?
- 求存储过程
- 请问如何导出数据库中的stored procedure对象?有没有命令可以使用?谢谢!
- 错误:ora-02778:name given for the log directory is invalid
- 为什么我的db_link建立后,查询时候提示无效的用户和密码。
- 关于Oracle数据库字符集
- Oracle 11G 求助
- 利用resultset分页
more /etc/oratab
export ORACLE_SID=sid
export ORACLE_HOME=home
然后用
echo $ORACLE_SID
echo $ORACLE_HOME
确认这两个环境变量正确设置,然后
sqlplus / as sysdba
_=/usr/bin/env
LANG=en_US
LOGIN=oracle
PATH=/usr/bin:/etc/:/usr/sbin:/usr/ucb:/usr/local/bin:/oracle/product/10g/bin:/usr/bin/X11:/sbin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/bin:/usr/bin/X11:/sbin:.:.:/oracle/splex/bin:/spo/prodir/bin
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
ORACLE_BASE=/oracle
LC__FASTMSG=true
obase=/oracle
CLASSPATH=/oracle/product/10g/jre:/oracle/product/10g/jre/1.1.8/lib:/usr/jdk_base:/usr/jdk_base:/usr/jdk_base/lib:/oracle/product/10g/rdbms/jlib:/oracle/product/10g/network/jlib
LOGNAME=oracle
MAIL=/usr/spool/mail/oracle
LOCPATH=/usr/lib/nls/loc
PS1=[oracle@S85-A]$PWD>
USER=oracle
AUTHSTATE=files
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
ORA_NLS33=/oracle/product/10g/ocommon/nls/admin/data
ohome=/oracle/product/10g
HOME=/oracle
TERM=vt100
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/oracle/product/10g
PWD=/oracle
TZ=BEIST-8
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/oracle/product/10g/lib:/oracle/product/10g/ctx/lib:/usr/lib:
LD_LIBRARY_PATH=/oracle/product/10g/lib:/lib:/usr/lib:/usr/local/lib
[oracle@S85-A]/oracle> env $ORACLE_HOME
/oracle/product/10g: The file access permissions do not allow the specified action.
[oracle@S85-A]/oracle/product/10g>export ORACLE_HOME=home
[oracle@S85-A]/oracle/product/10g>echo $ORACLE_SID
EPCOLL
[oracle@S85-A]/oracle/product/10g>echo $ORACLE_HOME
home
[oracle@S85-A]/oracle/product/10g>sqlplus "/as sysdba"
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory报这个错误! 该如何解决! 谢谢!!
这个安装路径可以用linux命令:
more /etc/oratab
看到,如
+ASM:/oracle/product/10.2.0/asm:Y
orcl:/oracle/product/10.2.0/db_1:Y上面的
ORACLE_SID=orcl
ORACLE_HOME=/oracle/product/10.2.0/db_1
你的Audit_trail设置为OS了吧,而对应审计文件路径还给设错了。
先把这些更改一下(把审计关掉,Audit_trail=NONE)试试。
怎么提示的都是审计错误啊
你的Audit_trail设置为OS了吧,而对应审计文件路径还给设错了。
先把这些更改一下(把审计关掉,Audit_trail=NONE)试试。
[/Quote问题是sqlplus 进不去,怎么修改啊?