1. Olan Knight
  2. PowerBuilder
  3. Monday, 19 August 2019 15:27 PM UTC

HELP!

When we "upgraded" to Oracle 12C from Oracle 11g several years ago, we started seeing the following EVERY. SINGLE. TIME. we connected to a database in both SQL+ and when running a script in SQL+.

We use standard PL/SQL and run the scripts in SQL+.

This occurs even when the script has NO "Set" commands included.

Can anyone tell me how to turn off these two things/prevent them from being generated or displayed:

   1)  SP2-0158:  unknown SET option "set"

   2) Tracefile will be: D:\APP\ORAADMIN01\PRODUCT\12.1.0\DBHOME_1\RDBMS\TRACE\sbtrn12d_ora_13508.trc
       D:\APP\ORAADMIN01\PRODUCT\12.1.0\DBHOME_1\RDBMS\TRACE\sbtrn12d_ora_13508.trc


   I have scoured the internet for a solution to either issue, to no avail.


Thank You,

Olan

René Ullrich Accepted Answer Pending Moderation
  1. Tuesday, 20 August 2019 10:39 AM UTC
  2. PowerBuilder
  3. # 1

Hi Olan,

I think SP2 is an SQLPlus error message.

there is somewhere a SQLPlus SET command. From error message it must be a command that starts with

"SET set".

If there is no such command in your script I guess that you use some automatic script like a login script that is not ok? (https://docs.oracle.com/cd/B28359_01/server.111/b31189/ch2.htm)

 

HTH,

René

Comment
  1. Olan Knight
  2. Tuesday, 20 August 2019 13:34 PM UTC
Thanks, Rene!

I am manually writing these scripts in Notepad++, and the error occurs even when there are ZERO "Set" commands in the script. It's bizarre.



Olan
  1. Helpful
  1. René Ullrich
  2. Tuesday, 20 August 2019 13:38 PM UTC
Hi Olan,

if there are no login scripts that runs automatically I don't know what it could be.
  1. Helpful
There are no comments made yet.
Mark Lee @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 20 August 2019 09:58 AM UTC
  2. PowerBuilder
  3. # 2

Hi Olan,

 

Sorry that i haven't encountered this issue before.

Can you find the old install path(Oracle 11g) in the Path in the System variables of the Environment variables? If yes, please delete it and restart the compute and try again. Hope this can resolve your problem.

Regards,

 

Comment
  1. Olan Knight
  2. Tuesday, 20 August 2019 13:37 PM UTC
Thanks and good call, Mark!

As it turns out I have an Oracle 11g client connecting to Oracle 12C databases. Let me check how the Oracle 12 client behaves!



Olan
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.