Re: Creating Oracle accounts: usernames and passwords under Red Hat Linux 6.1

Oracle maintains its own sets of users and roles. On a fresh install two users exist:
UID = system
PW = manager
The above user has DBA rights, the other user account is: UID = internal
PW = change_on_install
These two users are GOD, hence the above two user passwords should be modified as soon as you have verified a successful install.

Therefore to start sqlplus type the follwoing at the command prompt >sqplus system/manager_at_ORCL
ORCL is the OracleSID, your OracleSID should be web.

Also ensure that you have create a tns listener session so the client can connect to the db. You need to create a LISTENER server (/oracle/network/admin/listener.ora) DATABASE SERVICE FOR EACH SID (/oracle/network/admin/listener.ora) and a Net80 Client services (/oracle/network/admin/tnsnames.ora) This can be achieved by running the $ORACLE_HOME/bin/netasst ......java program.

Regards
Peter Winters
Cairns, Queensland, AUSTRALIA.

Jerry Asher <asher.nospam_at_nospam.autobahn.org> wrote in message news:_6tf4.49$_e4.3782_at_nnrp1-w.snfc21.pbi.net...
> So I believe I have Oracle 8i set up (Red Hat 6.1), and I have created an
> initial database (SID=web), but whenever I try to connect, sqlplus quickly
> tells me that I have:
>
> ERROR:
> ORA-01017: invalid username/password; logon denied
>
> I have tried connecting to Oracle when logged in to Linux as user Oracle
in
> group dba. I have tried as root (which is in group dba as a supplementary
> member).
>
> So how in general do I set up accounts in Oracle?
>
> How do I get Oracle to respect the accounts and privileges of the
underlying
> Linux system (using /etc/passwd, etc....)
>
> Thanks!
>
> Jerry
> asher.nospam_at_nospam.autobahn.org (remove the nospam to email of course)
>
>
Received on Thu Jan 13 2000 - 20:34:45 CST