SQL error 1552 occurred when accessing program SAP

[Former Member]

Hi All,

NW2004s, Widnows 2003 server/ Oracle 10g

I just restart Solution Manager and all instance looks Green and works fine... but when I try to access SAP-GUI and try to login I got that messages:

SOL: SAP System Message:

SQL error 1552 occurred when accessing program SAP

Please verify what elvel I have to check...

Thanks

[former_member204746 · Accepted solution]

read http://ora-01552.ora-code.com/

also, check for more info in file alert_SID.log

[Former Member · Accepted solution]

Thanks you so much for reply

This is log file details

how to I change that paramater even I can't access any Transaction code in SAP

please veryfiy

Thu Jan 28 09:45:24 2010

Adjusting the default value of parameter parallel_max_servers

from 80 to 65 due to the value of parameter processes (80)

Thu Jan 28 09:45:24 2010

Starting ORACLE instance (normal)

Thu Jan 28 09:45:25 2010

Specified value of sga_max_size is too small, bumping to 679477248

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Angeline

[former_member204746 · Accepted solution]

This parameter can be changed as per SAP note 830576. this is NOT done through SAP, it is done through a text editor or through sqlplus.

[Former Member · Accepted solution]

Hi Eric,

I am not very good for SQL DataBASE site, but I can tell you what I did... as I maintion some sga_max_size is very low in log profile so I search in google how to increase size...

I login sqlplus / as sysdba

show sga;

Total System Global Area 679477248 bytes

Fixed Size 2056000 bytes

Variable Size 348127424 bytes

Database Buffers 322961408 bytes

Redo Buffers 6332416 bytes

Database mounted.

Database opened.

Alter system set sga_max_size=100m scope=spfile;

shutdown immediate;

startup;

After startup oracle instance I got same value as like above...

basically I got this error when I try to login SAP gui... and put my user name and password... I got messages:

SQL: SAP system message:

SQL error 1552 occurred when accessing program SAP

your help really appriciated

Angelin

[former_member524429 · Accepted solution]

Hi,

SQL: SAP system message:
SQL error 1552 occurred when accessing program SAP

SQL 1552, points to problem with UNDO or ROLLback segments. May be your UNDO files are having recovery status.

Please check them and If they are with RECOVERY/OFFLINE status then do the following to correct the same.

Please post the output of the following command

sqlplus / as sysdba

select file#, status, name from v$datafile; (check the status of file with the file number)

If your UNDO file is showing recovery/offline status, please run the following additional commands to correct them.

recover datafile #NUMBER;

alter database datafile #NUMBER online;

where #NUMBER is a File number of "UNDO.DATA1" data file as mentioned in v$datafile.

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Jan 30, 2010 11:29 AM

[former_member204746 · Accepted solution]

again, I recommend reading SAP note 830576. It will give you a very good idea on what values you should use to set every Oracle parameters.

[Former Member · Accepted solution]

Hi there,

I really appricated your all help... basically problem still there... so strange

1. SAPMMC all instance are GREEN and look fine, J2EE engine is GREEN too...

2. From SAP GUI system log me in, and after user name and password I got this messages:

SOL: SAP System Message:

SQL error 1552 occurred when accessing program SAP

3. I loging in SQL plus / as sysdba

4. shutdown;

5. startup ;

6. no error found

7. Run recover;

8. nothing shows anyting....

9. I try one by one all datafile recover such as like

SQL> recover datafile 'F:\oracle\SID\sapdata1\system_1\sap.data1' ;

I treid all of them but nothing any damaged!!!

Restart SAP from MMC and shutdown server and restart it again... sameting...

Please help me step by step

Thank you

[former_member524429 · Accepted solution]

Hi,

Please post the output of the following command,

> sqlplus / as sysdba

> select file#, status, name from v$datafile;

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi again

I am Angeline, wowowo, thats really good, thaqnk you sooooo much you are really smart, the problem has been resolved, and I follow again same you told me

Thank a lot