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: ORA-01017 Invalid Password, Login Denied, Initial DBA Admin account

Re: ORA-01017 Invalid Password, Login Denied, Initial DBA Admin account

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 27 Feb 2004 07:36:29 -0600
Message-ID: <athu3057b6ie821rp5c6q9a8k51j36bc7o@4ax.com>


On 26 Feb 2004 15:27:24 -0800, glassjawslipknot_at_hotmail.com (Less Than 0) wrote:

>We just set up a new Oracle 9i server on Linux. Edited the
>TNSNAMES.ORA file, changed the IP, left everything else the same. Now
>when i try to login throuh SQL*Plus I get ORA-01017: invalid
>username/password; login denied. My question is not why im receiving
>that because its pretty obvious. But i do need to know how to set up
>an initial DBA Admin account on the linux server so that i can login
>to it from SQL*Plus and create accounts from there. Or, i need to know
>what services need to be started in order for me to be able to login
>to the server. We had Oracle 8i running fine. But the most experience
>i ever got with that was logging onto the admin account and creating
>users from there. So im pretty sure if i can get a DBA admin account
>on the server and login to it from SQL plus that i can get the rest
>from there. I really would apreciate some help. Thank you all.

Make sure there is a group named 'dba' and you are a member of that group. Than you should be able to 'connect / as sysdba'. Received on Fri Feb 27 2004 - 07:36:29 CST

Original text of this message

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