單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(7)
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1):http://space.itpub.net/81227/viewspace-701181
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2):http://space.itpub.net/81227/viewspace-701198
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3):http://space.itpub.net/81227/viewspace-701231
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4):http://space.itpub.net/81227/viewspace-701293
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5):http://space.itpub.net/81227/viewspace-702254
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6):http://space.itpub.net/81227/viewspace-702263
安裝過程中遇到的問題:ORA-01031: insufficient privileges
$ ll orapw*
-rw-r----- 1 oracle oinstall 1536 04-11 16:03 orapworcl
-rw-rw---- 1 ora10gstby oinstall 1536 07-01 15:18 orapwstby
$ sqlplus "sys/…@stby as sysdba"
ERROR:
ORA-01031: insufficient privileges
原因為orapwstby檔案的屬主不是oracle,將檔案屬主改為oracle問題解決。
開始設想新建一個ora10gstby使用者,所屬組與oracle使用者一樣,配置檔案與oracle使用者的唯一區別是ORACLE_SID,ora10gstby使用者是stby,oracle使用者是orcl,用不同使用者登入,可以直接啟動或關閉相應的例項。但實際情況是,因為在一臺機上安裝二個instance,合用了一個listener,故而出現上述問題。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-702264/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(10)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(9)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1)LinuxOracle 10g
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(7)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(6)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(5)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(4)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(3)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(2)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(1)LinuxOracle
- 單機Linux平臺Oracle 10g DataGuard Logical Standby 搭建例項LinuxOracle 10g
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項OracleLinux
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項-3OracleLinux
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項 -2OracleLinux
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項 -1OracleLinux
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(6)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(5)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(4)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(3)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(2)LinuxOracle
- Oracle 10G windows 平臺 DataGuard 例項Oracle 10gWindows
- 配置 Oracle 10g 單例項物理dataguard和邏輯standbyOracle 10g單例
- 在Oracle 10g下單機Physical StandbyOracle 10g
- 配置 Oracle 10g RAC primary + RAC physical standby dataguardOracle 10g
- 【DG】在Linux平臺上搭建單例項的dataguard--duplicateLinux單例
- Linux平臺Oracle 11g DataGuard Physical Standby 非正常關閉後的啟動LinuxOracle
- Oracle11g 搭建單例項DataGuardOracle單例
- DataGuard:Physical Standby Switchover
- 【DG】在Linux平臺上搭建單例項的dataguard--rman還原方式Linux單例
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- DataGuard:Physical Standby FailoverAI
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase