Your frustration with what is going on can be understood. Sometimes you need an additional pair of eyes to know what you are doing wrong. Sorry, we do not know about your case as much as I would want at this time before suggesting you more. But, please make sure that you know where or on what device/disk/filesystem are you writing your database files. It could be possible that you think you are writing to filesystem xxx but in fact you are not. You really need to double check that you have sufficient space on '/ora01/oracle/admin/DEVOLTP/link/' filesystem. Let us say you have all 30 GB space there. If you say 'yes' you have plenty space there then probability is that you are having a hardware problem on this device. In this scenario try changing bdump parameter in your init.ora file to a different filesystem for test purposes and see if you get reported an error on the new device also. I really wish you good luck and a quick solution to your problem.
Gurmohan
www.onlymath.com - Place to learn and teach math.
-----Original Message-----
From: David Chiu
[mailto:oracledba-ezmlmshield-x80114308.[Email address protected]
Sent: Wednesday, November 30, 2005 5:01 PM
To: LazyDBA Discussion
Subject: Import issue
Still trying to figure it out before I blow it away and recreate the
instance and run the import.
I have the instance created with 16G sga, enough temp/undos/redos
spaces.
I layout all my data/index files nicely, with leave plenty space for
future grow.
9 data files(3G each)
9 index files (3G each)
Export copy contain 10 dump files (3G each)
Import using parfile addressing those export dump files.
Nothing really unusual,
And I know I have done this many times.
The import crash the instance,
And it won't allow me to re-open the database. I can only mount it.
If nothing else, I will have to blow it away, and start from re-create
the instance..
------------------------------------------------------------------------
----
David Chiu
-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x82072603.[Email address protected]
Sent: Wednesday, November 30, 2005 3:51 PM
To: LazyDBA Discussion
Subject: RE: 10g client
Of course, being a new system, places to check could be archive log
directories... without a backup they could empty for this instance.
Autoextending your datafiles until disk space is exhausted when in fact
you have other disks available. Export file pretty big and on that
disk. Backups hanging around that are using space.
Look for core dumps usually in your cdump directory. Or try the find
command with the size ...
Linux flavor
Find <start_dir> -size +100 -exec -ls -l {} \; Find . -size +100 -exec
-ls -l {} \; Etc.
-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x42761370.[Email address protected]
Sent: Wednesday, November 30, 2005 3:03 PM
To: LazyDBA Discussion
Subject: RE: 10g client
Pay attention to where it say no space left on device. You are running
out of space on whereever you are importing.
Gurmohan
www.onlymath.com - Place to learn and teach math.
-----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
--------
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
--------
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