Re: Newbie cannot login

Hi newbie, thanks for writing this:
>
> "Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message
> news:MPG.19932557f4b37a4898981a_at_news.la.sbcglobal.net...
>
> > 1. Open a DOS window
> > 2. Type the following sqlplus commands:
> >
> > c:\> set ORACLE_SID=test1
> > c:\> sqlplus /nolog
> > sql> connect / as sysdba
>
> It was Ok till here but
> at this point it asks for username & password
> This is where I have problems.
> Same as the popup windows that asks for username & password
>

Unless you (or someone else) changed the default password, you should be able to login to 8i with sys/change_on_install (in 9i, you are "forced" to change this default password when you create the db). This is the default password for the SYS account on every 8i database I've ever installed on Windows or Solaris.

However, you should not be prompted for an Oracle userid/password if both of the following conditions are true:

1. Your Win userid is in the Administrator group OR your Win userid is in the ORA_DBA group.
2. Your %ORACLE_HOME%\network\admin\sqlnet.ora file contains this line: sqlnet.authentication_services=(nts). This basically tells Oracle to use your ability to login to Windows (with the correct group) for Oracle authentication.

Of course, you need to verify that you either have a single oracle home; or if you have multiple oracle homes, that your %oracle_home% environment variable is pointing to the correct one.

If this doesn't solve your problem, then you might need to call Oracle tech support to help you verify your database configuration. Not a brush off ... I just can't see any reason why you can't login based on the info you've supplied.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]