on 11-12-2006 7:21 PM
Hi,
currently i can connect sucessfully to databse using ora<sid> user with sysdba privilages.
prdadm>sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Sun Nov 12 14:05:33 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL>
but when i tried to connect remote login
SQL> connect orapms/<password>@PRD
ERROR:
ORA-01017: invalid username/password; logon denied
SQL>
but to solve my problem , i need also to create oraprd user in internal db.and assign dba privilages.
Can we create this user ? is it will conflict with OPS$PRDADM?
any idea?
Thanks
Lisa
hmm...the question is: does ora<sid> need to have these privilages? i don't think so...the adm-user is the one who does! ora<sid> does not have a record within SAPUSER table ...OPS$<SID>ADM is the entry....
-> check sapnot 50.088 (will also work for unix)
-> check sapnote 400.214
try to connect via sqlplus and > connect sapr3/<pwd>@<SID> (or sap schema-User) and check if it works! the ops$-user is needed to pass through the password for user sapr3 (or sap schema user) in order to connect to the database...so, if your <sid>adm is able to connect (try for example: sapdba -u / ) and is able to use the br-tools, everything should be ok!
GreetZ, AH
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.