1846209 Members
5279 Online
110255 Solutions
New Discussion

Re: file system error

 
Nago
Advisor

file system error

thanks for your response.
i am still having some problems.
when i try to export oracle data from the NFS client file system, i get the following error;
no such device,

About to export specified tables via Conventional Path ...
. . exporting table ACTB_HISTORYNo such device or address

EXP-00002: error in writing to export file
EXP-00002: error in writing to export fileerror closing export file
EXP-00000: Export terminated unsuccessfully002>
11 REPLIES 11
Ravi_8
Honored Contributor

Re: file system error

Hi,

In oracle data will be residing in tables. you can't NFS mount a oracle filesystem and work. since oracle database bound to hostname/IP of the machine on which it is running(look in tnsnames.ora file). you can use oracle link to connect to remote database and get the view of the remote database.
never give up
T G Manikandan
Honored Contributor

Re: file system error

What is the command you are using to export the data

$exp /@instance file= full/owner..

Are you specifying the right path.Is the path existing.
Can you post your command and description as what task you are really performing.

Nago
Advisor

Re: file system error

Sorry, I'm sure u didnt get the history of my problem. Earlier on I had a problem with my NFS file system. from the NFS client file system , I sit in a directory to export data from my oracle database. now i am having a problem exporting data from this NFS file system. This file system
failed to respond at a time when i was exporting data. i had to quickly restart the NFS client and the NFS server and the file system picked up on the client. however i get 'no such device error' while running export from this file system.I hope u get this now. pls help me...
T G Manikandan
Honored Contributor

Re: file system error

What is your database installed.
you should run the export from the machine where is the database and Oracle server installation is available.

THanks
Ravi_8
Honored Contributor

Re: file system error

Nago

bit confusion, sometimes you say NFS client and some times oracle server.
NFS concept is:

sysetm A and system B. you want to mount a filesyetm in A on to B.
In A open /etc/exports file make an entry for filesystem to be exported (specify -rw if you want to write into, since by default all exported filesystems will be read only)
execute the command from A
#exportfs -a
#exportfs will show you the exported filesystem
Make sure NFS processes are running on both A and B (if not start them using #/sbin/init.d/nfs.server start
#/sbin/init.d/nfs.client start)

In B
#mount A:/ /
If B says A:not found
replace A with its IP
never give up
Ravi_8
Honored Contributor

Re: file system error

Nago

bit confusion, sometimes you say NFS client and some times oracle server.
NFS concept is:

sysetm A and system B. you want to mount a filesyetm in A on to B.
In A open /etc/exports file make an entry for filesystem to be exported (specify -rw if you want to write into, since by default all exported filesystems will be read only)
execute the command from A
#exportfs -a
#exportfs will show you the exported filesystem
Make sure NFS processes are running on both A and B (if not start them using #/sbin/init.d/nfs.server start
#/sbin/init.d/nfs.client start)

In B
#mount A:/ /
If B says A:not found
replace A with its IP
never give up
Nago
Advisor

Re: file system error

I do the export from the NFS client - a mounted NFS file system where the oracle is installed. i usually do this for three years now. it only gave me 'no such device' error after the NFS server problem i reported
Ravi_8
Honored Contributor

Re: file system error

Nago

bit confusion, sometimes you say NFS client and some times oracle server.
NFS concept is:

sysetm A and system B. you want to mount a filesyetm in A on to B.
In A open /etc/exports file make an entry for filesystem to be exported (specify -rw if you want to write into, since by default all exported filesystems will be read only)
execute the command from A
#exportfs -a
#exportfs will show you the exported filesystem
Make sure NFS processes are running on both A and B (if not start them using #/sbin/init.d/nfs.server start
#/sbin/init.d/nfs.client start)

In B
#mount A:/ /
If B says A:not found
replace A with its IP
never give up
Ravi_8
Honored Contributor

Re: file system error

Nago

bit confusion, sometimes you say NFS client and some times oracle server.
NFS concept is:

sysetm A and system B. you want to mount a filesyetm in A on to B.
In A open /etc/exports file make an entry for filesystem to be exported (specify -rw if you want to write into, since by default all exported filesystems will be read only)
execute the command from A
#exportfs -a
#exportfs will show you the exported filesystem
Make sure NFS processes are running on both A and B (if not start them using #/sbin/init.d/nfs.server start
#/sbin/init.d/nfs.client start)

In B
#mount A:/ /
If B says A:not found
replace A with its IP
never give up
Ravi_8
Honored Contributor

Re: file system error

Nago

bit confusion, sometimes you say NFS client and some times oracle server.
NFS concept is:

sysetm A and system B. you want to mount a filesyetm in A on to B.
In A open /etc/exports file make an entry for filesystem to be exported (specify -rw if you want to write into, since by default all exported filesystems will be read only)
execute the command from A
#exportfs -a
#exportfs will show you the exported filesystem
Make sure NFS processes are running on both A and B (if not start them using #/sbin/init.d/nfs.server start
#/sbin/init.d/nfs.client start)

In B
#mount A:/ /
If B says A:not found
replace A with its IP
never give up
Ravi_8
Honored Contributor

Re: file system error

Nago

bit confusion, sometimes you say NFS client and some times oracle server.
NFS concept is:

sysetm A and system B. you want to mount a filesyetm in A on to B.
In A open /etc/exports file make an entry for filesystem to be exported (specify -rw if you want to write into, since by default all exported filesystems will be read only)
execute the command from A
#exportfs -a
#exportfs will show you the exported filesystem
Make sure NFS processes are running on both A and B (if not start them using #/sbin/init.d/nfs.server start
#/sbin/init.d/nfs.client start)

In B
#mount A:/ /
If B says A:not found
replace A with its IP
never give up