Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error: "Error creating view SYS.SHAREPLEX_KTFBUE - please grant sysdba privilege to SYSTEM" when
설명
Error received when running ora_setup:
"Error! Error creating view SYS.SHAREPLEX_KTFBUE - please grant sysdba privilege to SYSTEM and re-run ora_setup or run lmt_setup.sh with a user with sysdba privilege."
원인
Cause can be one or more of the following:
1. The dba user provided to ora_setup lacking sysdba privilege 2. O7_DICTIONARY_ACCESSIBILITY is set to false
해결 방안
Ora_setup will attempt to run the lmt_setup.sh script from the bin sub-directory of the Shareplex product directory automatically. If ora_setup is unable to do so, manually run the lmt_setup.sh script. This script creates the SYS.SHAREPLEX_KTFBUE view exposing SYS.X$KTFBUE and grants select privilege on this view to the Shareplex Oracle user.
1. Verify that the DBA user provided to ora_setup have the sysdba privilege.
2. Verify that the O7_DICTIONARY_ACCESSIBILITY is set to true OR 'grant select any dictionary to SPLEX' in 9i.
Because Oracle 9i+ by default has set the O7_DICTIONARY_ACCESSIBILITY to False, 'grant select any dictionary to splex' must be granted in 9i so that Shareplex can access dictionary information.
For oracle 8i and if you set O7_DICTIONARY_ACCESSIBILITY=FALSE, then you need to 'grant select_catalog_role to splex'.
3. Run lmt_setup.sh, this will create the SYS.SHAREPLEX_KTFBUE view.
