How to change the password of USER "INTERNAL"?
Chim Ian
I'd like to know how to change the password of USER "INTERNAL"?
Please teach me step by step to do it.
Thanks in advance.
mailto:ian...@yahoo.com
victor
Chim Ian <ian...@yahoo.com> wrote in article
<3641C54A...@yahoo.com>...
if you forget it sorry , no comment
else connect internal/password;
alter user internal identified by newpassword;
this all
µR§Q!
in svrmgr
i can connect "internal".
but when i type "alter user internal identified by newpassword".
It appear "ORA-01918: user 'internal' does not exist"
why I can't change the password?
Moogle
>That's the point,
>in svrmgr
>i can connect "internal".
>but when i type "alter user internal identified by newpassword".
>It appear "ORA-01918: user 'internal' does not exist"
>why I can't change the password?
>
>victor wrote:
internal is a synonym for sys.
You shouldn't even need a password to connect internal if you are logging on
from the oracle account on the server.
And you can't connect as internal from any other machine. If you are
worried about people connecting as internal to your database, just restrict
access to svrmgr to the oracle user.
To change the sys password...
So connect as sys or system or internal and do alter user sys identified by
<password>;
then internal and sys passwords will be changed.
Andrew Protasov
Hi,
Password of internal is usually in password file, not
in the database. Password file is named pwd<sid>.ora.
Program to create new password file is orapwd80.exe
(digits can be different in your case):
E:\ORANT\BIN>ORAPWD80/EXE /?
Usage: orapwd file=<fname> password=<password> entries=<users>
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
Shutdown database before changing password file.
Andrew Protasov
> That's the point,
> in svrmgr
> i can connect "internal".
> but when i type "alter user internal identified by newpassword".
> It appear "ORA-01918: user 'internal' does not exist"
> why I can't change the password?
>
> victor wrote:
> >
> > Chim Ian <ian...@yahoo.com> wrote in article
> > <3641C54A...@yahoo.com>...
> > > Hi all,
> > > I'd like to know how to change the password of USER "INTERNAL"?
> > > Please teach me step by step to do it.
> > >
> > > Thanks in advance.
> > > mailto:ian...@yahoo.com
> > >
> >
> > if you forget it sorry , no comment
> > else connect internal/password;
> > alter user internal identified by newpassword;
> >
> > this all
>
>
sa...@my-dejanews.com
ask you for a password if your UNIX user account does not belong to the DBA
group.
Satar
In article <AK02f...@protasov.kiev.ua>,
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Stephen Tenberg
ever happens, but my NT 8.04 install doesn't have a pwd*.* in ANY directory,
whats up?
Steve
sa...@my-dejanews.com wrote in message <71vcbp$d20$1...@nnrp1.dejanews.com>...
Stephen Tenberg
Stephen Tenberg wrote in message <727btt$qfq$1...@news1.epix.net>...
Dan
> Please teach me step by step to do it.
The problem with questions such as your is that my suspicion is that if
you had any business doing this you would already know how. The fact
that you are asking a basic DBA question and wanting step-by-step
instructions leads me to believe that you have no business attempting to
do this and are probably up to no good.
That said, the answer to your question, in cryptic form that will be of
no use to you unless you are a qualified DBA is . . . use oradim to drop
an recreate the SID.
Daniel A. Morgan
max
>
>You shouldn't even need a password to connect internal if you are logging on
>from the oracle account on the server.
>And you can't connect as internal from any other machine. If you are
>worried about people connecting as internal to your database, just restrict
>access to svrmgr to the oracle user.
>
>To change the sys password...
>So connect as sys or system or internal and do alter user sys identified by
><password>;
>then internal and sys passwords will be changed.
>
>
network. I'm wondering WHY other people can connect as internal to my
database without entering a password from their computer???
Any answer ?
How may I avoid that?
tia
Max rome(italy)
Paul Rahe
Hi,
If you're using NT, you can change the internal password by using the
NT instance manager. Be sure to use the NT instance manager and not
the Oracle intance manager to change the internal password.
-Paul
Claudia Payer
> On Mon, 23 Nov 1998 21:07:42 GMT, m.pan...@flashnet.it (max) wrote:
>
> >
> >>
> >>You shouldn't even need a password to connect internal if you are logging on
> >>from the oracle account on the server.
> >>And you can't connect as internal from any other machine.
That's wrong, at least for NT server. I have to give the user "internal" a
password. After that I can connect with Oracle Instance Manager to the database
and startup and shutdown.
If I give the user "internal" on a AIX machine a password, I even can connect
without password directly at the server (svrmgr), but I can use the user
"internal" with password to connect remote with OIM.
I'm tried to startup and shutdown AIX databases with user sys, but I can't. That's
the reason, because I use the "internal".
> If you are
> >>worried about people connecting as internal to your database, just restrict
> >>access to svrmgr to the oracle user.
> >>
> >>To change the sys password...
> >>So connect as sys or system or internal and do alter user sys identified by
> >><password>;
> >>then internal and sys passwords will be changed.
I think, both user "sys" and "internal" are different. At my area, they have
different passwords. -> ??
>
> >>
> >>
> >well, I've Personal Oracle 7.3 on my NT computer, at work. It's in a
> >network. I'm wondering WHY other people can connect as internal to my
> >database without entering a password from their computer???
> >Any answer ?
> >How may I avoid that?
> >tia
> >Max rome(italy)
> Hi,
>
> If you're using NT, you can change the internal password by using the
> NT instance manager. Be sure to use the NT instance manager and not
> the Oracle intance manager to change the internal password.
>
> -Paul
Bye,
Claudia
Stefan Llabres
>
> Paul Rahe wrote:
>
> > On Mon, 23 Nov 1998 21:07:42 GMT, m.pan...@flashnet.it (max) wrote:
> >
> > >
> > >>
> > >>You shouldn't even need a password to connect internal if you are logging on
> > >>from the oracle account on the server.
> > >>And you can't connect as internal from any other machine.
>
> That's wrong, at least for NT server. I have to give the user "internal" a
> password. After that I can connect with Oracle Instance Manager to the database
> and startup and shutdown.
> If I give the user "internal" on a AIX machine a password, I even can connect
[...]
> I'm tried to startup and shutdown AIX databases with user sys, but I can't. That's
> the reason, because I use the "internal".
[...]
Tried "connect system as sysdba" instead of "connect system"?
Bye, Stefan... . .
max
>If you're using NT, you can change the internal password by using the
>NT instance manager. Be sure to use the NT instance manager and not
>the Oracle intance manager to change the internal password.
>
>-Paul
What do you mean when you say 'NT instance manager' ?
thanks
max rome(italy)
Paul Rahe
When you run Oracle on an NT box, you have two instance managers, one
of them is called the Oracle instance manager and the other one is
called the NT instance manager.
The NT instance manager is the tool you use to create the instance in
the first place. This is what you use to specify the maximum number
of datafiles, the data block size, the location of the system catalog,
stuff like that. It's also the tool you use to create and/or change
the password for the Internal userid.
The oracle instance manager is a tool that you can use to access the
database, signed on with the Internal userid, to perform operations
like mounting and unmounting the database from the instance.
-Paul
we...@collogia.de
I have a problem like yours.
I sit on a database sercver and want connect me as internal.
So I start up the svrmgrl and type connect internal.
In the next step I need a password. I know this password, but I dont't want a
password for this action.
How can I delete the password for connect internal?
Thanks a lot
Frank
max wrote:
> >
> >You shouldn't even need a password to connect internal if you are logging on
> >from the oracle account on the server.
> >And you can't connect as internal from any other machine. If you are
> >worried about people connecting as internal to your database, just restrict
> >access to svrmgr to the oracle user.
> >
> >To change the sys password...
> >So connect as sys or system or internal and do alter user sys identified by
> ><password>;
> >then internal and sys passwords will be changed.
> >
> >
John P. Higgins
Sylvain Leclerc
instance password
(on NT anyway).
Sylvain Leclerc, DBA
INT Systèmes d'information
slec...@magrit.com
we...@collogia.de
Frank
Steve Haynes
On NT, internal and sys are not synonymous (8.0.5).
I can change the internal password via orapwd80
and sys via alter user.
Steve
--
Please remove nospam from my address to Reply.