Re: help me : got error while creating datafile in NAS(nfs file system) on HPUX ()
From: joel garry <joel-garry_at_home.com>
Date: Thu, 22 Apr 2010 10:06:24 -0700 (PDT)
Message-ID: <2e44c04e-1861-4fd7-96f3-1941393cde96_at_q31g2000prf.googlegroups.com>
On Apr 22, 7:53 am, "jayendra.ahmedabad.acute" <i.jayen..._at_gmail.com> wrote:
> syntax:
>
> CREATE OR REPLACE FUNCTION
> FUNC_GET_ANY_DAY_FD_AC_PROV
> (A_COMP_CD FD_BALANCE_MST.COMP_CD%TYPE,
> A_BRANCH_CD FD_BALANCE_MST.BRANCH_CD%TYPE,
> A_ACCT_TYPE FD_BALANCE_MST.ACCT_TYPE%TYPE,
> A_ACCT_CD FD_BALANCE_MST.ACCT_CD%TYPE,
> A_ASON_DATE FD_BALANCE_MST.TRN_DATE%TYPE)
> RETURN NUMBER AS
> PROD FD_BALANCE_MST.AMOUNT%TYPE:=0;
> BEGIN
> BEGIN
> SELECT SUM( NVL(M.PROV_INT_AMT,0)) INTO PROD
> FROM FD_BALANCE_MST M,
> (SELECT
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,M.FD_NO,MAX(TRN_DATE)
> TRN_DATE
> FROM FD_BALANCE_MST M
> WHERE COMP_CD = A_COMP_CD AND
> BRANCH_CD = A_BRANCH_CD AND
> ACCT_TYPE = A_ACCT_TYPE AND
> ACCT_CD = A_ACCT_CD AND
> TRN_DATE <=A_ASON_DATE
> GROUP BY
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,M.FD_NO
> )T
> WHERE M.COMP_CD = T.COMP_CD
> AND M.BRANCH_CD = T.BRANCH_CD
> AND M.ACCT_TYPE = T.ACCT_TYPE
> AND M.ACCT_CD = T.ACCT_CD
> AND M.FD_NO = T.FD_NO
> AND M.TRN_DATE = T.TRN_DATE
> GROUP BY M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD;
> EXCEPTION WHEN NO_DATA_FOUND THEN
> PROD := 0;
> END;
> RETURN PROD;
> END FUNC_GET_ANY_DAY_FD_AC_PROV;
> /
>
> SELECT *
> FROM (SELECT --
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,
>
> SUM(FUNC_GET_ANY_DAY_BALANCE(T2.COMP_CD,T2.BRANCH_CD,T2.GL_INT_TYPE,T2.GL_INT_ACCT_CD,sysdate))
> BBAL,
> SUM(M.PRO_BAL) FBAL, SUM(M.BAL) FBBAL
> FROM (SELECT
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,
> SUM(NVL(M.PROV_INT_AMT,0)) AS
> PRO_BAL,
>
> FUNC_GET_ANY_DAY_FD_AC_PROV(M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,sysdate)
> BAL
> FROM FD_DTL M
> -- WHERE TRIM(COMP_CD) = TRIM(COMP)
> -- AND TRIM(BRANCH_CD) =
> TRIM(BRANCH)
> GROUP BY
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD
> ) M ,
> ACCT_TYPE_MST T2
> WHERE M.COMP_CD = T2.COMP_CD
> AND M.BRANCH_CD = T2.BRANCH_CD
> AND M.ACCT_TYPE = T2.ACCT_TYPE
> -- AND M.ACCT_CD = T2.ACCT_CD
> -- AND M.ACCT_TYPE BETWEEN 200 AND 215
> )
> WHERE ( (NVL(BBAL,0)-NVL(FBBAL,0)) <> 0 OR
> (NVL(FBAL,0)-NVL(FBBAL,0)) <> 0
> )
> ;
>
> 'LOC','LOC0','SH','SH01','REC','RECM','SB','SB01','CA','CA01','AUTO','FA01','FA02','FAU1','FAU2','FCUM','FD','FD01','FD02','IFDN','IFCN','IFDA','IFCA'
>
> ;
>
> SELECT M.COMP_CD, M.BRANCH_CD, M.ACCT_TYPE, M.ACCT_CD
> FROM ACCT_MST M
> WHERE EXISTS ( SELECT *
> FROM (SELECT COMP_CD,BRANCH_CD,ACCT_TYPE
> FROM ACCT_TYPE_MST
> -- WHERE COMP_CD = COMP
> -- AND BRANCH-CD = BRANCH
> WHERE PARENT_TYPE IN ( SELECT CODE
> FROM SYS_TYPE_MST
> WHERE PARENT_CODE
> IN('LOC','LOC0','SH','SH01','REC',
>
> 'RECM','SB','SB01','CA','CA01',
>
> 'AUTO','FA01','FA02','FAU1','FAU2',
>
> 'FCUM','FD','FD01','FD02','IFDN',
>
> 'IFCN','IFDA','IFCA')
> )
> ) T
> WHERE M.COMP_CD = T.COMP_CD
> AND M.BRANCH_CD = T.BRANCH_CD
> AND M.ACCT_TYPE = T.ACCT_TYPE
> )
> AND NVL(CONF_BAL,0) < 0
>
> ;
>
> SELECT *
> FROM (SELECT M.COMP_CD, M.BRANCH_CD, T.GL_TYPE
> ACCT_TYPE, T.GL_ACCT_CD ACCT_CD,
> SUM(NVL(CONF_BAL,0)) MBAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD, T.GL_TYPE, T.GL_ACCT_CD,SYSDATE) GBAL
> FROM ACCT_MST M,
> ACCT_TYPE_MST T
> WHERE /*COMP_CD = COMP
> AND BRANCH_CD = BRANCH
> AND*/ M.COMP_CD = T.COMP_CD
> AND M.BRANCH_CD = T.BRANCH_CD
> AND M.ACCT_TYPE = T.ACCT_TYPE
> AND ( ( NVL(T.CR_GL_TYPE,'0') = '0' AND
> NVL(T.CR_GL_ACCT_CD,'0') = '0'
> )OR
> ( NVL(T.DR_GL_TYPE,'0') = '0' OR
> NVL(T.DR_GL_ACCT_CD,'0') = '0'
> )
> )
> AND ( ( NVL(T.GL_TYPE,'0') <> '0' AND
> NVL(T.GL_ACCT_CD,'0') <> '0'
> )
> )
> GROUP BY M.COMP_CD, M.BRANCH_CD, T.GL_TYPE,
> T.GL_ACCT_CD
> )
> WHERE MBAL <> GBAL
> ;
>
> SELECT *
> FROM (SELECT M.COMP_CD, M.BRANCH_CD,
>
> SUM(FUNC_GET_ANY_DAY_IR_BALANCE(M.COMP_CD, M.BRANCH_CD,
>
> M.ACCT_TYPE,
>
> M.ACCT_CD,
>
> SYSDATE)
> ) MBAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,211)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,212)),
> SYSDATE)
> REC_BAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,213)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,214)),
> SYSDATE)
> RES_BAL
> FROM ACCT_MST M
> -- WHERE TRIM(M.COMP_CD) = TRIM(COMP)
> -- AND TRIM(M.BRANCH_CD) = TRIM(BRANCH)
> WHERE TRIM(M.COMP_CD) = '132'
> AND TRIM(M.BRANCH_CD) = '002'
> GROUP BY M.COMP_CD, M.BRANCH_CD
> )
> WHERE ABS(MBAL) = ABS(REC_BAL) OR
> ABS(MBAL) = ABS(RES_BAL)
> ;
>
> SELECT *
> FROM (SELECT M.COMP_CD, M.BRANCH_CD,
>
> SUM(FUNC_GET_ANY_DAY_IR_BALANCE(M.COMP_CD, M.BRANCH_CD,
>
> M.ACCT_TYPE,
>
> M.ACCT_CD,
>
> TRAN_DAT)
> ) MBAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,211)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,212)),
> TRAN_DAT)
> REC_BAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,213)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,214)),
> TRAN_DAT)
> RES_BAL
> FROM SHARE_WARRANT M
> WHERE TRIM(M.COMP_CD) = TRIM(COMP)
> AND TRIM(M.BRANCH_CD) = TRIM(BRANCH)
> GROUP BY M.COMP_CD, M.BRANCH_CD
> )
> WHERE ABS(MBAL) <> ABS(REC_BAL) OR
> ABS(MBAL) <> ABS(RES_BAL)
> ;
>
> SELECT *
> FROM (SELECT TO_COMP_CD, TO_BRANCH_CD,
> TO_ACCT_TYPE, TO_ACCT_CD,
> SUM(DIVIDEND_AMOUNT) DIV_AMT,
> FUNC_GET_ANY_DAY_BALANCE(TO_COMP_CD,
> TO_BRANCH_CD, TO_ACCT_TYPE, TO_ACCT_CD,
> SYSDATE) GBAL
> FROM SHARE_WARRANT
> WHERE /*TRIM(M.COMP_CD) = TRIM(COMP)
> AND TRIM(M.BRANCH_CD) = TRIM(BRANCH)
> AND */NVL(TO_COMP_CD,'X') <> 'X'
> AND NVL(TO_BRANCH_CD,'X') <> 'X'
> AND NVL(TO_ACCT_TYPE,'X') <> 'X'
> AND NVL(TO_ACCT_CD,'X') <> 'X'
> AND NVL(PAID,'N') = 'N'
> GROUP BY TO_COMP_CD, TO_BRANCH_CD,
> TO_ACCT_TYPE, TO_ACCT_CD
> )
> WHERE DIV_AMT <> GBAL
>
> CREATE TABLESPACE FCRDATA1
> EXTENT MANAGEMENT LOCAL
> SEGMENT SPACE MANAGEMENT AUTO
> DATAFILE '/nasora/fcrdata1_01.dbf' SIZE 100 M REUSE AUTOEXTEND ON
> NEXT 1 M,
> '/nasora/fcrdata1_02.dbf' SIZE 100 M REUSE AUTOEXTEND ON NEXT 1 M
> --,
> -- '/uatdata/oracle/oradata/FCR/fcrdata1_03.dbf' SIZE 10 M REUSE
> AUTOEXTEND ON NEXT 1 M
> AUTOALLOCATE
> LOGGING
> ONLINE
> PERMANENT
> BLOCKSIZE 8 K
> /
>
> --------------
> bdf result
> -------------
> drwxrwxrwx 2 root sys 96 Jul 13 2007 mnt
> drwxrwxrwx 5 oracle oinstall 103 Apr 22 20:03 nasora
> dr-xr-xr-x 2 root root 96 Nov 17 2006 net
> dr-xr-xr-x 70 bin bin 8192 Dec 21 2006 opt
> drwxrwxrwx 10 oracle oinstall 1024 Apr 22 13:15 oracle
> -rw-r--r-- 1 root sys 0 Feb 4 2008 oracle.prefs
> drwxrwxrwx 5 root sys 8192 Jun 26 2008 samba
> dr-xr-xr-x 15 bin bin 8192 Dec 21 2006 sbin
>
> ---------------------------
> Error
> ---------------------------
> ORA-01119: error in creating database file '/uatdata/oracle/oradata/
> FCR/fcrdata1_01.dbf'
> ORA-27086: unable to lock file - already in use
> HPUX-ia64 Error: 13: Permission denied
> Additional information: 8
>
> ---------------------------
>
> ---------------------------
>
> NAS(nfs file system) on HPUX
>
> NAS is os iomega (EMc system)
>
> please help me
Date: Thu, 22 Apr 2010 10:06:24 -0700 (PDT)
Message-ID: <2e44c04e-1861-4fd7-96f3-1941393cde96_at_q31g2000prf.googlegroups.com>
On Apr 22, 7:53 am, "jayendra.ahmedabad.acute" <i.jayen..._at_gmail.com> wrote:
> syntax:
>
> CREATE OR REPLACE FUNCTION
> FUNC_GET_ANY_DAY_FD_AC_PROV
> (A_COMP_CD FD_BALANCE_MST.COMP_CD%TYPE,
> A_BRANCH_CD FD_BALANCE_MST.BRANCH_CD%TYPE,
> A_ACCT_TYPE FD_BALANCE_MST.ACCT_TYPE%TYPE,
> A_ACCT_CD FD_BALANCE_MST.ACCT_CD%TYPE,
> A_ASON_DATE FD_BALANCE_MST.TRN_DATE%TYPE)
> RETURN NUMBER AS
> PROD FD_BALANCE_MST.AMOUNT%TYPE:=0;
> BEGIN
> BEGIN
> SELECT SUM( NVL(M.PROV_INT_AMT,0)) INTO PROD
> FROM FD_BALANCE_MST M,
> (SELECT
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,M.FD_NO,MAX(TRN_DATE)
> TRN_DATE
> FROM FD_BALANCE_MST M
> WHERE COMP_CD = A_COMP_CD AND
> BRANCH_CD = A_BRANCH_CD AND
> ACCT_TYPE = A_ACCT_TYPE AND
> ACCT_CD = A_ACCT_CD AND
> TRN_DATE <=A_ASON_DATE
> GROUP BY
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,M.FD_NO
> )T
> WHERE M.COMP_CD = T.COMP_CD
> AND M.BRANCH_CD = T.BRANCH_CD
> AND M.ACCT_TYPE = T.ACCT_TYPE
> AND M.ACCT_CD = T.ACCT_CD
> AND M.FD_NO = T.FD_NO
> AND M.TRN_DATE = T.TRN_DATE
> GROUP BY M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD;
> EXCEPTION WHEN NO_DATA_FOUND THEN
> PROD := 0;
> END;
> RETURN PROD;
> END FUNC_GET_ANY_DAY_FD_AC_PROV;
> /
>
> SELECT *
> FROM (SELECT --
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,
>
> SUM(FUNC_GET_ANY_DAY_BALANCE(T2.COMP_CD,T2.BRANCH_CD,T2.GL_INT_TYPE,T2.GL_INT_ACCT_CD,sysdate))
> BBAL,
> SUM(M.PRO_BAL) FBAL, SUM(M.BAL) FBBAL
> FROM (SELECT
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,
> SUM(NVL(M.PROV_INT_AMT,0)) AS
> PRO_BAL,
>
> FUNC_GET_ANY_DAY_FD_AC_PROV(M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD,sysdate)
> BAL
> FROM FD_DTL M
> -- WHERE TRIM(COMP_CD) = TRIM(COMP)
> -- AND TRIM(BRANCH_CD) =
> TRIM(BRANCH)
> GROUP BY
> M.COMP_CD,M.BRANCH_CD,M.ACCT_TYPE,M.ACCT_CD
> ) M ,
> ACCT_TYPE_MST T2
> WHERE M.COMP_CD = T2.COMP_CD
> AND M.BRANCH_CD = T2.BRANCH_CD
> AND M.ACCT_TYPE = T2.ACCT_TYPE
> -- AND M.ACCT_CD = T2.ACCT_CD
> -- AND M.ACCT_TYPE BETWEEN 200 AND 215
> )
> WHERE ( (NVL(BBAL,0)-NVL(FBBAL,0)) <> 0 OR
> (NVL(FBAL,0)-NVL(FBBAL,0)) <> 0
> )
> ;
>
> 'LOC','LOC0','SH','SH01','REC','RECM','SB','SB01','CA','CA01','AUTO','FA01','FA02','FAU1','FAU2','FCUM','FD','FD01','FD02','IFDN','IFCN','IFDA','IFCA'
>
> ;
>
> SELECT M.COMP_CD, M.BRANCH_CD, M.ACCT_TYPE, M.ACCT_CD
> FROM ACCT_MST M
> WHERE EXISTS ( SELECT *
> FROM (SELECT COMP_CD,BRANCH_CD,ACCT_TYPE
> FROM ACCT_TYPE_MST
> -- WHERE COMP_CD = COMP
> -- AND BRANCH-CD = BRANCH
> WHERE PARENT_TYPE IN ( SELECT CODE
> FROM SYS_TYPE_MST
> WHERE PARENT_CODE
> IN('LOC','LOC0','SH','SH01','REC',
>
> 'RECM','SB','SB01','CA','CA01',
>
> 'AUTO','FA01','FA02','FAU1','FAU2',
>
> 'FCUM','FD','FD01','FD02','IFDN',
>
> 'IFCN','IFDA','IFCA')
> )
> ) T
> WHERE M.COMP_CD = T.COMP_CD
> AND M.BRANCH_CD = T.BRANCH_CD
> AND M.ACCT_TYPE = T.ACCT_TYPE
> )
> AND NVL(CONF_BAL,0) < 0
>
> ;
>
> SELECT *
> FROM (SELECT M.COMP_CD, M.BRANCH_CD, T.GL_TYPE
> ACCT_TYPE, T.GL_ACCT_CD ACCT_CD,
> SUM(NVL(CONF_BAL,0)) MBAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD, T.GL_TYPE, T.GL_ACCT_CD,SYSDATE) GBAL
> FROM ACCT_MST M,
> ACCT_TYPE_MST T
> WHERE /*COMP_CD = COMP
> AND BRANCH_CD = BRANCH
> AND*/ M.COMP_CD = T.COMP_CD
> AND M.BRANCH_CD = T.BRANCH_CD
> AND M.ACCT_TYPE = T.ACCT_TYPE
> AND ( ( NVL(T.CR_GL_TYPE,'0') = '0' AND
> NVL(T.CR_GL_ACCT_CD,'0') = '0'
> )OR
> ( NVL(T.DR_GL_TYPE,'0') = '0' OR
> NVL(T.DR_GL_ACCT_CD,'0') = '0'
> )
> )
> AND ( ( NVL(T.GL_TYPE,'0') <> '0' AND
> NVL(T.GL_ACCT_CD,'0') <> '0'
> )
> )
> GROUP BY M.COMP_CD, M.BRANCH_CD, T.GL_TYPE,
> T.GL_ACCT_CD
> )
> WHERE MBAL <> GBAL
> ;
>
> SELECT *
> FROM (SELECT M.COMP_CD, M.BRANCH_CD,
>
> SUM(FUNC_GET_ANY_DAY_IR_BALANCE(M.COMP_CD, M.BRANCH_CD,
>
> M.ACCT_TYPE,
>
> M.ACCT_CD,
>
> SYSDATE)
> ) MBAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,211)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,212)),
> SYSDATE)
> REC_BAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,213)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,214)),
> SYSDATE)
> RES_BAL
> FROM ACCT_MST M
> -- WHERE TRIM(M.COMP_CD) = TRIM(COMP)
> -- AND TRIM(M.BRANCH_CD) = TRIM(BRANCH)
> WHERE TRIM(M.COMP_CD) = '132'
> AND TRIM(M.BRANCH_CD) = '002'
> GROUP BY M.COMP_CD, M.BRANCH_CD
> )
> WHERE ABS(MBAL) = ABS(REC_BAL) OR
> ABS(MBAL) = ABS(RES_BAL)
> ;
>
> SELECT *
> FROM (SELECT M.COMP_CD, M.BRANCH_CD,
>
> SUM(FUNC_GET_ANY_DAY_IR_BALANCE(M.COMP_CD, M.BRANCH_CD,
>
> M.ACCT_TYPE,
>
> M.ACCT_CD,
>
> TRAN_DAT)
> ) MBAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,211)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,212)),
> TRAN_DAT)
> REC_BAL,
> FUNC_GET_ANY_DAY_BALANCE(M.COMP_CD,
> M.BRANCH_CD,
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,213)),
>
> TRIM(FUNC_SYS_PARA_MST_VALUE(M.COMP_CD,M.BRANCH_CD,214)),
> TRAN_DAT)
> RES_BAL
> FROM SHARE_WARRANT M
> WHERE TRIM(M.COMP_CD) = TRIM(COMP)
> AND TRIM(M.BRANCH_CD) = TRIM(BRANCH)
> GROUP BY M.COMP_CD, M.BRANCH_CD
> )
> WHERE ABS(MBAL) <> ABS(REC_BAL) OR
> ABS(MBAL) <> ABS(RES_BAL)
> ;
>
> SELECT *
> FROM (SELECT TO_COMP_CD, TO_BRANCH_CD,
> TO_ACCT_TYPE, TO_ACCT_CD,
> SUM(DIVIDEND_AMOUNT) DIV_AMT,
> FUNC_GET_ANY_DAY_BALANCE(TO_COMP_CD,
> TO_BRANCH_CD, TO_ACCT_TYPE, TO_ACCT_CD,
> SYSDATE) GBAL
> FROM SHARE_WARRANT
> WHERE /*TRIM(M.COMP_CD) = TRIM(COMP)
> AND TRIM(M.BRANCH_CD) = TRIM(BRANCH)
> AND */NVL(TO_COMP_CD,'X') <> 'X'
> AND NVL(TO_BRANCH_CD,'X') <> 'X'
> AND NVL(TO_ACCT_TYPE,'X') <> 'X'
> AND NVL(TO_ACCT_CD,'X') <> 'X'
> AND NVL(PAID,'N') = 'N'
> GROUP BY TO_COMP_CD, TO_BRANCH_CD,
> TO_ACCT_TYPE, TO_ACCT_CD
> )
> WHERE DIV_AMT <> GBAL
>
> CREATE TABLESPACE FCRDATA1
> EXTENT MANAGEMENT LOCAL
> SEGMENT SPACE MANAGEMENT AUTO
> DATAFILE '/nasora/fcrdata1_01.dbf' SIZE 100 M REUSE AUTOEXTEND ON
> NEXT 1 M,
> '/nasora/fcrdata1_02.dbf' SIZE 100 M REUSE AUTOEXTEND ON NEXT 1 M
> --,
> -- '/uatdata/oracle/oradata/FCR/fcrdata1_03.dbf' SIZE 10 M REUSE
> AUTOEXTEND ON NEXT 1 M
> AUTOALLOCATE
> LOGGING
> ONLINE
> PERMANENT
> BLOCKSIZE 8 K
> /
>
> --------------
> bdf result
> -------------
> drwxrwxrwx 2 root sys 96 Jul 13 2007 mnt
> drwxrwxrwx 5 oracle oinstall 103 Apr 22 20:03 nasora
> dr-xr-xr-x 2 root root 96 Nov 17 2006 net
> dr-xr-xr-x 70 bin bin 8192 Dec 21 2006 opt
> drwxrwxrwx 10 oracle oinstall 1024 Apr 22 13:15 oracle
> -rw-r--r-- 1 root sys 0 Feb 4 2008 oracle.prefs
> drwxrwxrwx 5 root sys 8192 Jun 26 2008 samba
> dr-xr-xr-x 15 bin bin 8192 Dec 21 2006 sbin
>
> ---------------------------
> Error
> ---------------------------
> ORA-01119: error in creating database file '/uatdata/oracle/oradata/
> FCR/fcrdata1_01.dbf'
> ORA-27086: unable to lock file - already in use
> HPUX-ia64 Error: 13: Permission denied
> Additional information: 8
>
> ---------------------------
>
> ---------------------------
>
> NAS(nfs file system) on HPUX
>
> NAS is os iomega (EMc system)
>
> please help me
Did you try running just the create tablespace command manually? What is all that other stuff? Are you trying to do ddl in a function? Who are you logged in as?
Does the file exist? What are the protections on the directories between the bdf and the file?
MOS 145194.1 mentions there could be spurious locks on the NAS, I don't know enough about it to know if that applies, but maybe your admin does.
Was there a crash?
What is the protection on the Oracle executable? What is the value of your nflocks kernel parameter?
What are the exact versions of everything?
jg
-- _at_home.com is bogus. http://www.krazydad.com/blog/2010/02/mayor-of-the-north-pole/Received on Thu Apr 22 2010 - 12:06:24 CDT