cancel
Showing results for 
Search instead for 
Did you mean: 

Brtools not crete table space on network drive

Former Member
0 Kudos

Dear Sir

we create Tablespace on NSF File system for SUM need,we use AIX server

and we create on 100 GB NFS for SUM but when we go thrue Brtools give

error from user ORAARD..

On NFS we create Manuel file and Folder also thru ORAARD user but form

brtools we not able to create Tablse sapce i send log also

AIL 5.3 and Oracle 11.2.

nainesh

9376998808

Log of Brtools

Error************************************************************************************

BR0319I Control file copy created:

/oracle/ARD/sapreorg/selodqpc/cntrlARD.old 13942784

BR0280I BRSPACE time stamp: 2013-07-03 08.22.55

BR1089I Creating tablespace PSAPSR3700X ...

BR0280I BRSPACE time stamp: 2013-07-03 08.22.55

BR0301E SQL error -1119 at location BrSqlExecute-1, SQL statement:

'/* BRSPACE */ create tablespace PSAPSR3700X extent management local

autoallocate segment space management auto datafile

'/mnt/ARD/sapdata5/sr3700x_1/sr3700x.data1' size 2000M autoextend off'

ORA-01119: error in creating database file

'/mnt/ARD/sapdata5/sr3700x_1/sr3700x.data1'

ORA-27054: NFS file system where the file is created or resides is not

mounted with correct options

Additional information: 5

Additional information: 2

BR1017E Execution of SQL statement '/* BRSPACE */ create tablespace

PSAPSR3700X extent management local autoallocate segment space management

auto datafile '/mnt/ARD/sapdata5/sr3700x_1/sr3700x.data1' size 2000M

autoextend off' failed

BR0280I BRSPACE time stamp: 2013-07-03 08.22.55

BR0669I Cannot continue due to previous warnings or errors - you can go

back and repeat the last action

************************************************************************************

View Entire Topic
karthikeyan_natarajan4
Active Contributor
0 Kudos

Hi Nainesh,

while mounting the nfs file system, use the below mentioned parameters

mount -F nfs -o hard,bg,proto=tcp,vers=3,suid,rsize=32768,wsize=32768,intr,noac

the, try creating the new tablespace

Former Member
0 Kudos

Dear Karthiken

172.17.13.5:/installdump/ecc6 : NFS filesystem

/mnt/ARD  : Mount point

when i give command

root@sapdevail:/etc#mount -F nfs -o hard,bg,proto=tcp,vers=3,suid,rsize=32768,wsize=32768,intr,noac 172.17.13.5:/installdump/ecc6 /mnt

mount: Not a recognized flag: F

Usage: mount [-fipr] [-n Node] [-o Options] [-t Type] [-{v|V} Vfs]

        [-a | all | [[Node:]Device] [Directory]]

root@sapdevail:/etc#

please guide me

karthikeyan_natarajan4
Active Contributor
0 Kudos

Hi Nainesh,

Please paste the content of /etc/filesystems

Former Member
0 Kudos

Dear Kerthik

we not add in filesysem

i send u log

/oracle/ARD/sapdata4:

        dev             = /dev/data4lv

        vfs             = jfs2

        log             = /dev/loglv01

        mount           = true

        check           = false

        options         = cio,rw

        account         = false

/installdump:

        dev             = /dev/dumplv

        vfs             = jfs2

        log             = /dev/loglv01

        mount           = true

        check           = false

        options         = rw

        account         = false

root@sapdevail:/etc#

Now can add it or not

nainesh

Former Member
0 Kudos

Dear Alll

My drive is

172.17.13.5 /installdump/ecc6 /mnt         nfs3   Jul 02 19:58

how we wrine in

/mnt:

        dev             = 172.17.13.5/installdump/ecc6/mnt

        vfs             = nfs3

        log             = /dev/loglv01

        mount           = true

        check           = false

        options         = rw

        account         = false

it ok or not please tell

nainesh

karthikeyan_natarajan4
Active Contributor
0 Kudos

Hi Nainesh,

Add the entry in filesystem and try changing the vfs = nfs3 to just nfs.

Former Member
0 Kudos

Dear Friend

we add entry in

/mnt:

        dev             = /installdump/ecc6

        vfs             = nfs

        nodename        = 172.17.13.5

        log             = /dev/loglv01

        mount           = true

        check           = false

        options         = rw

        type            = nfs_mount

        account         = false

But still erro is same

nainesh

Former Member
0 Kudos

Try to change

options = bg,soft,intr,rsize=32768,wsize=32768

remount /mnt filesystem and try again.

See also Note 1120072 - ORA-27054 and NFS file system.

Former Member
0 Kudos

Dear All


This parameter (Note are show)are not in my oracle 11.2 profile

nainesh

Former Member
0 Kudos

Change mount options only. Do not set event 10298 (or use it as temporary solution).

Former Member
0 Kudos

Yes We usr for Temporary we chage in

etc/filesystem

/mnt:

        dev             = /installdump/ecc6

        vfs             = nfs

        nodename        = 172.17.13.5

        log             = /dev/loglv01

        mount           = true

        check           = false

        options         = rw,bg,hard,intr,rsize=32768,wsize=32768, timeo=600,vers=3,proto=tcp,noac,sec=sys

        type            = nfs_mount

        account         = false

and my problem is solved

Thansk