Skip to Content
avatar image
Former Member

Brtools not crete table space on network drive

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 03, 2013 at 04:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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