当我尝试在Linux下连接oracle数据库时,它抛出了如下错误:
SQL> conn / as sysdba
ERROR:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space left on device
df命令显示没有剩余空间,文件系统已满。我想知道每个表空间的大小以及如何释放空闲表空间。谢谢!
在删除表空间之前,我错误地删除了数据文件。但是表空间占用了很大的空间。我需要移除它,有什么方法吗?
它会发生:
DROP TABLESPACE abc;
*
ERROR at line 1:
ORA-01116: error in opening database file 8
ORA-01110: data file 8: '/data/oradata/oracle/abc.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional inform
误差
Warning: oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in
Warning: oci_connect(): Error while trying to retrieve text for error ORA-01804
apache php oracle安装方法
1.
我使用impdp导入备份。但是我想要更改默认目录dumpfile。
$ impdp system/password@$ORACLE_SID schemas=USER_SCHEMA dumpfile=mydumpfile.dmp logfile=impdpmydumpfile.log
Import: Release 11.2.0.3.0 - Production on Mon Mar 16 09:32:05 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected
我想将我的PLSQL开发人员工具连接到数据库中,但由于下面的错误而连接失败。ORA-12514: TNS:侦听器当前不知道连接描述符中请求的服务
检查下面的配置。如何配置才能使其正常工作?
SQL> select value from v$parameter where name='service_names';
VALUE
orcl
SQL> select instance from v$thread;
INSTANCE
orcl
SQL> select host_name,instance_name,version from v$instance;
HO
我在ubuntu14.04上安装了oracle11g,启动lister,消息如下所示。
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 10-OCT-2014 14:20:02
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
我正试图在我的ubuntu服务器上安装Oracle数据库11g速成版。运行命令后:
sudo service oracle-xe start
在配置之后,我得到以下结果:
Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for de
新手问题。我正在读一本非常好的书。当我尝试使用Marshal一节中的magic_copy示例时,我更接近浏览器而不是终端,所以我在ocsigen的中尝试了一下,我很惊讶地得到了结果:
(* js_of_ocaml *)
# let ora_magic_copy a =
let s = Marshal.to_string a [Marshal.Closures] in
Marshal.from_string s 0;;
val ora_magic_copy : 'a -> 'b = <fun>
# (ora_magic_copy 2 : fl
我使用的是CentOS 7,我的ORACLE_HOME和ORACLE_XE设置正确。然而,当我试图配置我的oracle 11g时,我会得到以下错误:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
LRM-00116: syntax error at 'sessions' following '='
ORA-01078: failure in processi
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0.1/db_1/dbs/initAWSDB.ora'
我使用dbca创建了一个新的Oracle 12c数据库。
dbs目录中的唯一文件
$ ls -ltrh
total 24K
-rw-r--r--. 1 oracle oinstall 3.1K May 15 2015 init.ora
-rw-r-
我在VMWare Player上有一个虚拟机: Linux Centos上的Oracle11g。由于我已经两年没有使用它了,我几乎什么都不记得了,当我尝试启动数据库时,它会显示listener is down,而当我尝试启动listener时,它会显示:
TNSLSNR for Linux Version 11.2. 0.1.0 - Production
System Parameter file is /oracle/product/11gR2/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/sr