Re: INTERNAL PROFILE = SYS?

This is a different problem than what you think. Oracle allows you to grant sysdba to users you specify if the REMOTE_LOGIN_PASSWORDFILE parameter in the init.ora file is set to EXCLUSIVE. On NT, if memory serves me correctly it defaults to PUBLIC, hence the error you're seeing. Change the entry in the init.ora file (or add it if it's not there), restart the database and you should be OK.

HTH. Pete

Daniel Guzman wrote:

> In article <7rtscq$hc6$1_at_nnrp1.deja.com>,
> AleX <korrozia_at_my-deja.com> wrote:
> > In article <7rtja7$a7l$1_at_nnrp1.deja.com>,
> > Daniel Guzman <dan_at_guzman.net> wrote:
> > > -hope this doesn't appear twice. lost my session while posting.
> > > Hello. We are using an Oracle 8.0.5 DB on NT and I am having
> problems
> > > getting into it via sqlplus. I have a couple of newbie questions:
> > >
> > > 1. How do you find out the service name?
> >
> > Look it up in your local tnsnames.ora file
> >
> > > 2. Is the HOST STRING(SQL PLUS) the same as the service name?
> >
> > Yes ( but then again it can be anything depending on your tns setting)
> >
> > > 3. Is there a way to grant sysoper or sysdba using system or sys?
> > > 4. Can you grant sysdba through gui interface?
> > >
> >
> > You're better off simply creating DBA accounts.
> >
> > > My boss changed the sys password and I can't get in using the
> interal
> > > profile anymore on the box. I thought the INTERNAL profile was and
> > > alias to SYS or SYSTEM. I also tried the SYSTEM profile's pwd. We
> > > need to create a profile and give this profile the sysdba role so we
> > > can start and stop the server. Forgive the newbie questions
> normally
> > a
> > > dba would handling this, but we don't have one. And aren't getting
> > > one. Thanks,
> >
> > You need to have either a sys or a system password. if connecting as
> > sys, make sure to connect as
> > connect sys/password as sysdba
> >
> > Thx
> > --
> > Alex Shterenberg
> > "I hate people. I think they should suffer as much as
> > possible, and therefore I'm into those old communist
> > dictatorships." - Euronymous, Mayhem
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
> Thanks. I still can't figure out how to connect as sysdba using sql
> plus. Let me clarify. I am able to login to the gui Enter. Manager
> using INTERNAL now and there is a drop down box that has 3 options
> Normal, SYSDBA, and SYSOPER. I click on SYSDBA and I am able to start
> and stop the instance so I am in as sysdba. Now, I want to create a
> user that can do this instead of using INTERNAL. I go into the
> Security Manager GUI and find the user I want to grant SYSDBA to and
> the system role/priv and when I try to apply it I get an error. It
> says "cannot add users to public password file." I tried this through
> sql plus and get the same error. I am using grant sysdba to username.
> Using sql plus I don't connect as sysdba, but I get the same result as
> being logged into the gui as sysdba. Where to you put all the text for
> connect sys/password as sysdba from the sql plus gui with user,
> password, and connect boxes? I can connect doing internal/password in
> just the user box of the sql plus gui but not with internal/password as
> sysdba. Thanks again.
> --
> Web Application Programmer
> 3Com Corporation

>

Received on Fri Sep 17 1999 - 14:45:54 CDT