cancel
Showing results for 
Search instead for 
Did you mean: 

Error installing SAP ECC v6.0 SR3 IDES

Former Member
0 Kudos

Hi,

I need help installing sap I am getting error on the database creation phase. I am using windows server 2008 central install with oracle database v11.2.3.0. The database has been created and I can connect to the database and mount through sqlplus. When I check error on the ora_sql_results.log  as below:

ORA-01017: invalid username/password; logon denied
SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

Checked if the system user is locked and its not locked as per attached screenshot.

I would appreciate help if anyone has come across this issue.

Macdonald.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Just to add thats the error on the on the ora_sql_results.log:

2015-10-24, 23:16:32 SAPINST ORACLE start logging for

@@D:\oracle\EMP\11203/sqlplus/admin/pupbld.sql

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 24 23:16:32 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus

SAPINST: End of output of SQL executing program D:\oracle\EMP\11203/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2015-10-24, 23:16:32 SAPINST ORACLE stop logging

JamesZ
Advisor
Advisor
0 Kudos

Hi Macdonald,

Please check if below can connect database:


log on os via user sidadm

sqlplus /nolog

conn /@dbsid

If above shows error ORA-01017, please check ops$ setting for user sidadm according to SAP note

400241.


Best regards,
James

Former Member
0 Kudos

Hi James,

Thanks so much for prompt reply I am getting error on command conn /@dbsid logged as SIDadm:

ORA-12154: TNS:could not resolve the connect identifier specified

Regards,

Macdonald

JamesZ
Advisor
Advisor
0 Kudos

Dear Macdonald,


Can you show me with the screenshot?

@dbsid means @<datbase sid>

Former Member
0 Kudos

Hie James,

Yes I changed SID to my database sid as per screenshot attached.

JamesZ
Advisor
Advisor
0 Kudos

No, the command you should us is:

conn /@EMP


as mentioned

If above shows error ORA-01017, please check ops$ setting for user sidadm according to SAP note

400241.

Former Member
0 Kudos

James my apologies, this is the correct screenshot:

JamesZ
Advisor
Advisor
0 Kudos

seems listener is not starting, so use command below:

sqlplus /nolog

conn /

Former Member
0 Kudos

Hi James,

Listener service was not running so now I am getting this error

ORA-01017: invalid username/password; logon denied

I will check the sap note  400241 and update you. Thanks for your help on this.

Regards,

Macdonald

Former Member
0 Kudos

I have started the listener service manually

Former Member
0 Kudos

Hi James,

I have read the document on sap note 400241. If I run command "SELECT * FROM DBA_USERS WHERE USERNAME = 'OPS$EMP\EMPADM';" (EMP being my domain name as as well my SAPSID) from sqlplus it returns no rows which means my service account is not in the database. I am using windows server 2008 with oracle 11.2.0.3 installed. As well as "SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';" returns no rows selected. I need to be able to create sidadm service account on the database table and the note mentions how to create table and create user for NT. From your understanding are there simple commands or steps I can follow to do that.

Regards,

Macdonald

JamesZ
Advisor
Advisor
0 Kudos

Hi Macdonald,

I think you can just refer to part:

ora-01017: invalid username/password;logon denied.


The section already gives the sql commands we need.

Best regards,
James

Former Member
0 Kudos

Hi James,

Okay I get your point I really appreciate your help on this. I am having issues on creating the user as per note:

CREATE USER "OPS$<os_user>" DEFAULT TABLESPACE <user_tsp>

default tablespace giving error I have tried both PSAPUSER1D and  PSAP<sid>USR getting error tablespace does not exist. Not sure what I should use for the default tablespace to replace <user_tsp>.

Regards,

Macdonald

JamesZ
Advisor
Advisor
0 Kudos

Hi Macdonald,


you can create another tablespace, but the size does not need much big. 100MB should be enough.

Please note  you should use brtools to create another tablespace and then assign it to ops$ user.

Best regards,

James

Former Member
0 Kudos

Hi James,

Thanks again I am in the middle of learning SAP Basis. So I cannot create a new tablespace from sqlplus and if I need brtools do I need to have solution manger installed because at the present moment I do not have solution manager. Can you please shed more light on brtools.

Regards,

Macdonald

JamesZ
Advisor
Advisor
0 Kudos

okay, log on os via user sidadm, then go cmd.


solution manager is not needed. brtools should already in your database host.

brtools

2 - Space management
2 - Create tablespace


then input the menu 3 to assign a new to brtools

Afterwards you just need to follow the wizard to continue.

Best regards,

James

Former Member
0 Kudos

Hi James,

Could it be that the brtools are not yet installed since installation of sap is failing on the phase database creation though the database has already been created. Below is the error I am getting on brtools:

Regards,

Macdonald

JamesZ
Advisor
Advisor
0 Kudos

Hi Macdonald,

In that case, you can try to use sqlplus to connection as sysdba, then create tablespace.

Check if you are able to do that.

Also please past pupbld.sql from $oracle_home\..\admin directory.

Best regards,
James

Former Member
0 Kudos

Hi James,

I am not sure what you mean by "Also please past pupbld.sql from $oracle_home\..\admin directory". I have ready the sap note and these are the commands not sure which one I should run because I am getting error:

CREATE TABLE "OPS$<sid>ADM".SAPUSER

  (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

CREATE USER "OPS$<os_user>" DEFAULT TABLESPACE <user_tsp>

  TEMPORARY TABLESPACE PSAPTEMP IDENTIFIED EXTERNALLY;

which values should I replace getting on OPS$<sid>ADM and  OPS$<os_user> after replacing SID and os_user?

Thanks for your help once again.

Regards,

Macdonald

Former Member
0 Kudos

Hi James,

Now it dawned on me I got your point I need to create tablespace first called PSAP<SID>USR and I need to use this command but I am not sure of the location of datafile as well what you mean by "Also please past pupbld.sql from $oracle_home\..\admin directory"

CREATE TABLESPACE PSAP<SID>USR  DATAFILE '/<data location>/PSAP<SID>USR001.dbf' SIZE 250M

After creating tablespace then I will be able to create the user as per note sap.

Regards,

Macdonald

Former Member
0 Kudos

info when I check datatable location: