If the person's account is a member of the local NT group ORA_DBA they should be able to follow this procedure from the server console: - set ORACLE_SID=<SID> - sqlplus /nolog - connect internal/internal_password I've had 8.1.5 ignore incorrect or missing passwords when I use this feature so I always empty ORA_DBA except when I want to use it. That way (since instances have different passwords) I don't get into the wrong instance by mistake. It may now detect invalid passwords for ORA_DBA memebers but I've not had a reason to change the procedure... If they aren't able to get in that way or they're not at the server console they should be able to: - sqlplus /nolog - connect internal/internal_password@service_name ... assuming the listener is running on the server and everything's correctly configured. If neither works then: - verify that in the init.ora file you've configured remote_login_passwordfile = exclusive - verify in listener.ora that the service is correctly configured, and that you've used the same SID and service names in the procedures above. - verify that TNSNAMES.ORA or whatever naming method you use is configured properly for the service. - run ORADIM -edit -sid <sid> -intpwd <newpassword> at the console to reset the internal password to something you know. I've not had to go farther than this, so from there on you're on your own :-). Steven Hovington wrote: > I have someone on a remote site who is having problems connecting to a db in > server mgr as internal. > connect internal should work, but it replies with insufficient privileges, I > must be missing something. > > Does anyone have a suggestion what this could be? > > OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as > administrator. > > Thanks, > > Steven. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Hovington > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
