Re: Newbie cannot login

From: Newbie <newbie__--_at_usa.net>
Date: Fri, 1 Aug 2003 18:18:04 -0500
Message-ID: <bgesfe$mn54u$1@ID-158805.news.uni-berlin.de>

Karstan,
You are not half bad for one ugly Oracle DBA

In Oracle 8i
I added a user called sys as administrator with blank password in NT users Then I also added the line
sqlnet.authentication_services=(nts).

Then I tried to login
with sys / blank password ...it did not work But when I tried sys / change_on_install......fuck....it worked (BTW I did not need a host string in popup window)

I was also able to loginto Oracle Administrative Assistant successfully using same user / pw.

But to me this does not make sense unless the user "sys" has to be in NT admin group (with one password...blank in my case) but the same motherfucker "sys" has a different password "change_on_install" in the Oracle realm.............does this make sense ?

Anyway I am having trouble with 9i
But I have not investigated it.
However in 9i , as you said it did force me to change the PW (I know what it is) but won't let me in. I guess I have to add the user "sys" again ...you think......... or are there any additional stuff I have to do ?

Thanks anyway......but stop fucking flaming me in a separate post I accept your apology (implied by your being a good boy by responding to me) I forgive you :)

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.1994706854bad390989822_at_news.la.sbcglobal.net...
> 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]
Received on Fri Aug 01 2003 - 18:18:04 CDT