on 10-24-2015 11:10 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.