Any generic best default Oracle 12 connection parm settings?

1
0
-1

Using Oracle 12 with Appeon PB trying to be anal about runtime connection parms (mostly run thru Citrix).  Do you have any comments on existing settings below or recommendations to consider adding as a general "best" default?  Note for Sybase I used to append the user id to the app name parm so I could tell who was running on the server but not for Oracle.

DBParm = PWDialog = 0, PBCatalogOwner='data_schema_owner', CommitOnDisconnect = 'No', NcharLiteral = 'Yes', BindSPInput = 1, DelimitIdentifier = 'No', Appname = 'App Name'

Question Tags: 

Answers

David Peace answered Any generic best default Oracle 12 connection parm settings?

1
0
-1

Hi

We use this a code to set detail sin the module, we put the appname and version in the string. This allows us to check the version in the DB and prevent people updating data if they do not have the right version.

 

declare p2 procedure for
      DBMS_APPLICATION_INFO.SET_MODULE
      (:app_name,'Running') using SQLCA;
        
EXECUTE p2;

Hope that helps.

Cheers

David

david.sternberg_24147's picture

Thank you, but consider I code for app and db version protection differently.  I place the version in the app ini file that the exe uses to get the dbparm values and have the app version also in a db table.  Upon app connection, these two version values (ini / exe against db) are matched before the application opens, otherwise the user is informed to install the correct version of the application.

David Peace's picture

That's fine and typically how we check DB version too, but on large 24/7 systems we can upgrade the DB with users live and they get prompted to install the new version but can carry on read only in the meantime.

The point is that you can store anything you line n the Module and pick this up in code for use later.

Cheers

David

david.sternberg_24147's picture

Thank you.  I expected my post was a loaded question and much is left in the eyes of the beholder with various ways to achieve desired goals.  Further I guess most parameters are parameters because there are reasons to have various values under different philosophies and situations.  Thanks again for responding and have a great day.