Skip to Content
0
Former Member
Nov 12, 2006 at 07:19 PM

Additional remote access privilages to ora<SID>

95 Views

Hi,

currently i can connect sucessfully to databse using ora<sid> user with sysdba privilages.

oraprd>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/prd90fcp@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$ORAPRD ?

any idea?

Thanks

Lisa