Re: Problem connecting to a db

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_at_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: steven.hovington_at_procession.com
>
> 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: ListGuru_at_fatcity.com (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).
Received on Tue Jul 17 2001 - 09:41:27 CDT