cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle parameter value

Former Member
0 Kudos

Hi All,

Hi All,

We use HP UNIX, Oracle 10g. My question is, is there any tcode that can list current database parameters and its value, if there is no transaction, what is the way to list them and change if necessary.

Regards,

Manickam.V

Accepted Solutions (1)

Accepted Solutions (1)

former_member603052
Contributor
0 Kudos

Hi Arvind,

You can get the parameters in initSID.ora using db03 and tu02 and db26 tCodes

Kalyan

Former Member
0 Kudos

Hi arvind,

DB26 transaction where you can see the required database parameters value

to change parameters you can follow as given below

connect to database using sqlplus

sqlplus /nolog

connect / as sysdba

shutdown

create pfile from spfile;

It will create latest profile parameter file in initSID.ora in directory oracle/SID/102_64/dbs

open it and do changes or add paramters and values as per your requiremnt

follow the * syntax before each parameter. then save and exit

create spfile form pfile;

(note instance should not be running)

this will update your profile parameters for oracle

then start database again

Regards,

Nitin Salunkhe

Answers (2)

Answers (2)

former_member204746
Active Contributor
0 Kudos

transaction ST04OLD (if it does not work, use ST04)

Detailed Analysis button

Current parameter button

0 Kudos

Hi,

What is your SAP product/version?

You can find the current parameters on ST04, ST04N and/or DBACockpit.

You can also use the query attached to SAP note 1171650 in SQL plus or on the SQL editor in DBACockpit or on ST04N.

You cannot change the Oracle parameters from SAP.

You have to use SQLPLUS or BRTOOL.

Please, check the documentation in order to do so.

Former Member
0 Kudos

Hi Fidel,

SAP 4.7 ECC throws an error u201Cthe length of the current statement is greater thanu201D when I execute the script to check the Oracle 10.0.2 parameter that is attached with note 1171650.

By the way your answer was really helpful

Regards,

A.K.M

0 Kudos

Hi,

Unfortunately, old versions of the "sql editor" have limitations on the script length.

The only option you have is to run it on SQL plus.