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.
lmt_setup.sh fails with errors: "ORA-01031: insufficient privileges" and "SP2-0157: unable to CON
Description
When running lmt_setup.sh as root, it may fail with the errors "ORA-01031: insufficient privileges" and "SP2-0157: unable to CONNECT to ORACLE after 3 attempts" as the following session shows:
irvsupu16 # id uid=0(root) gid=1(other) irvsupu16 # pwd /u01/sha52/prod/bin irvsupu16 # ./lmt_setup.sh This script creates a view exposing SYS.X$KTFBUE and grants select privilege on this view to the SharePlex Oracle user. An Oracle logon with SYSDBA role is required to perform these steps.
Enter database ORACLE_SID:[quest10g]
Enter ORACLE_HOME:[/u00/oracle/product/10g]
Enter username for an Oracle logon with SYSDBA privilege: system Enter password for system: Enter username for SharePlex Oracle logon: sha52
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 22 09:50:40 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: ERROR: ORA-01031: insufficient privileges
Enter user-name: SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / Enter user-name: SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.