check and change parameter

[Former Member]

Hello sdn,

Could you tell how to check /change database parameters via Brtools commandline. I am not able to find it out. I need to check and change some parameters on Oracle for SAP.

Thanks

[anindya_bose · Accepted solution]

BRTOOLS

Option 1.. Instance Management---->Option 4 ( Alter Database Parameter) or Option 6 ( Show Database Parameter).

ALternatively, you can change in your initSID.ora file. To do that

Shutdown database

Change in initSID.ora file with a text editor like notepad

in the SQL prompt give a command like "create spfile from pfile"

then restart the database

[Former Member · Accepted solution]

When I do 6 for show paramters ,it asks for entering a string value for paramter ?

what is the string value : i want to display all the paramters.

Thanks

[Former Member · Accepted solution]

Use the command

SHOW PARAMETERS;

[former_member204746]

refer to SAP note 830576.