on 04-26-2011 8:37 PM
Ok. Not knowing where to post this I figured I start here.
I have just completed upgrading our database from Oracle 10.2.0.4 to 11.2.0.2
Now I get the following error when I try to get license information:
sapjbs:jbsadm 26> ./saplicense -show NAME=JBS
SAPLICENSE (Release 700) ERROR ***
ERROR: Connect to database failed
DETAILS: DbSlConnect failed with return code 99
SQL-ERROR 1017 (check DB manual for explanation)
1017 is username/password error. I looked at the SAP Notes and there is talk of a OPS$SIDADM user. Well, our install does not have that. It has a OPS$SR3ADM user. None of the Java Stack servers have a OPS$SIDADM user. Yes, the database is up.
My environment is set:
dbms_type=ORA
dbs_ora_tnsname=JBS
ORACLE_SID=JBS
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/JBS/112_64
And in the /usr/sap/JBS/JC00/work/dev_jcontrol file I find this:
[Thr 1] JControlICheckProcessList: license check failed
Any help? Thanks!
HP-UX 11.31 Oracle 11.2.0.2 Kernel 7.0 patch 221 (SP 20)
Hello Sir,
You need to create this user if they are not there in dba_users table.
As SIDADM invokes SAP tables always so you need to have the entry of OPS$SIDADM users.
Regards
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vince,
The SAP Application SID is owned by SIDADM so always SIDADM invokes SAPSR3 user inturn it will connect to DB using system user.
For ABAP schema sapsr3 is the owner where as for sapr3db is the owner for java schema.
I hope it makes it clear why it is looking for SIDADM user.
If you are directly talking the database without having an application then sysdba or a user with dba authorizations will do the act. Where as we are invoking DB using an application running on top of it so SIDADM in our case will own the SAP system OS level administrative rights.
Regards
Vivek
>
Whenever you install the license you will be using SLICENSE or saplicense executable which is again at the application level and your application is still owned by SIDADM.
The SAP license is still being owned by SIDADM not other user.
So why does the default installation NOT create and OPS$ user that get get and validate a license? Did something get missed in the install? Should I create the OPS$SIDADM user for this java stack system?
>
>
> " I have just completed upgrading our database from Oracle 10.2.0.4 to 11.2.0.2"
>
> I think you did upgrade and while doing it it might have dropped the users.
Nope. The user OPS$SIDADM doesn't exist on any of our Java Stack servers. ONLY R3 and BW.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
SQL> select username from dba_users;
USERNAME
-
OPS$SR3ADM
OPS$ORAJBP
SYS
SYSTEM
SAPSR3DB
OUTLN
TSMSYS
DIP
ORACLE_OCM
DBSNMP
It was the Java license and not the ABAP one (ie saplicense issue)
Checked on the license and it says there is a perm one installed.
Now I need to figure out why the perm one is not perm.
Thanks for everyones help. Been a fun adventure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In your case OPS$SR3ADM is the right user. Following are the notes which you can use to identify the issue:
SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle
SAP Note 361641 - Creating OPS$ users on UNIX
For more information why its OPS$SR3ADM and not OPS$SIDADM check the following thread:
Hope this helps.
Thanks,
Naveed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.