SP2-0642: "SQL*Plus Internal Error State 2147, Context 0:0:0 Unsafe To Proceed" For Specific Query as Non-Oracle User
(Doc ID 2487258.1)
Last updated on MAY 02, 2023
Applies to:
SQL*Plus - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Encounter the following error when executing a specific query using a Non-Oracle OS user that does not belong to any Oracle group:
SP2-0642: SQL*Plus internal error state 2147, context 0:0:0 unsafe to proceed
The same query WORK if:
- run sqlplus as the Oracle user.
- add the Non-Oracle user to Oracle install OS group.
- execute the query, with Non-Oracle user, using a TNS connection.
The same query FAILS if:
- run sqlplus as the Non-Oracle user.
- execute the query, with Non-Oracle user, using a local connection.
Test Case:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |