on 03-15-2009 12:09 PM
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
Hi Arvind,
You can get the parameters in initSID.ora using db03 and tu02 and db26 tCodes
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
transaction ST04OLD (if it does not work, use ST04)
Detailed Analysis button
Current parameter button
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.