Use the command 'df -all'; find the device that has a Use% of 100; that will
be the device you would need to make room in before you attempt your import
again.
Saju
-----Original Message-----
From: David Chiu
[mailto:oracledba-ezmlmshield-x35138.[Email address protected]
Sent: Wednesday, November 30, 2005 2:53 PM
To: LazyDBA Discussion
Subject: RE: 10g client
ALL:
The following error happen on a test instance during import and crash
the instance.
It looks like the DEV_DATA tablespace is corrupted.
I can only mount my database and not able to open the database, Since
this is a new dev instance, I don't have anything backup yet.
So, how can I get the database to open to fix the problem (I was
thinking to drop the tablespace and re-create it).
Thanks,
David C
Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit
Production With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path import
done in US7ASCII character set and AL16UTF16 NCHAR character set import
server uses UTF8 character set (possible charset conversion) . importing
DEVADM's objects into DEVADM
. . importing table "AD" 0 rows
imported
. . importing table "AD_ALERT" 0 rows
imported
. . importing table "AD_ALERT_RULE_TYPE" 0 rows
imported
. . importing table "AD_EMAIL_ITEM" 0 rows
imported
. . importing table "AD_FIRED_ALERT" 0 rows
imported
. . importing table "AD_FIRED_ALERT_COMMENT" 0 rows
imported
. . importing table "AD_FIRED_ALERT_INFO" 0 rows
imported
. . importing table "AD_QUALIFIER" 0 rows
imported
. . importing table "AD_TP_AND_ROLE" 0 rows
imported
. . importing table "AD_TP_ROLE_TYPE" 0 rows
imported
. . importing table "APP_LOG"
IMP-00058: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully
On the alert log file:
Here is the error:
KCF: write/open error block=0x1a98 online=1
file=30 /ora01/oracle/admin/DEVOLTP/link/test_data19.dbf
error=27063 txt: 'IBM AIX RISC System/6000 Error: 28: No space left
on device Additional information: -1 Additional information: 8192'
Wed Nov 30 17:31:37 2005
Errors in file
/ora01/oracle/admin/DEVOLTP/bdump/testoltp_dbw0_1699850.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG
mode
ORA-01114: IO error writing block to file 30 (block # 6808)
ORA-01110: data file 30:
'/ora01/oracle/admin/DEVOLTP/link/test_data19.dbf'
ORA-27063: skgfospo: number of bytes read/written is incorrect IBM AIX
RISC System/6000 Error: 28: No space left on device Additional
information: -1 Additional information: 8192
DBW0: terminating instance due to error 1242 Instance terminated by
DBW0, pid = 1699850
Thanks,
------------------------------------------------------------------------
----
David Chiu
-----Original Message-----
From: Peter Bojinov
[mailto:oracledba-ezmlmshield-x21000684.[Email address protected]
Sent: Wednesday, November 30, 2005 2:05 PM
To: LazyDBA Discussion
Subject: 10g client
I have installed 10g client on my machine. I was able to connect
todifferent databases using Net Manager. I am also available to use
SQLPlus Worksheet, but I cannot start SQLPlus and I can't use the ODBC
driver. When I tried to create DSN it happened, but when I tested the
connection it was gaving me an error message.
Thanks,
Peter.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page