Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie
There are some things you have pay attention to.
First you have to create a passwordfile with the orapwd utility. Because
administrative tasks works on database down, theres no chance for
database authentication.
Second you have to set your init.ora remote_login_passwordfile to exclusive.
Then you can change the accounts sys and system from the internal account
to sysdba (grant sysdba to system).
I hope that i don't forget any step.
1.orapwd file=orapw<SID> password=<internal> entries=100 (on SOLARIS in
$ORACLE_HOME/dbs)
2.change init.ora 3. restart 4. connect internal
grant sysdba to system;
commit;
I hope that will help you.
Andreas Prusch
In article <3569220B.7911948D_at_unipd.it>,
Daniel Nardin <daniel_at_unipd.it> wrote:
>
> Hello.
>
> I installed a Oracle 7.3.4 under solaris 2.5 for a test and it works
> properly. I also installed under a NT 4.0 Server "Oracle enterprise
> Manager" to perform administrative task.
> The problem is that when i try to login as SYS or SYSTEM with the option
> SYSDBA or SYSOPER it gives me an error message like "Invalid username or
> password". If i try to connect with the same user as NORMAL it works
> properly.
> Any insight would be greatly appreciated.
>
> Daniel Nardin
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 25 1998 - 10:23:40 CDT