Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie

Re: newbie

From: <andreas.prusch_at_sintec.de>
Date: Mon, 25 May 1998 15:23:40 GMT
Message-ID: <6kc2ds$43m$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US