Greetings to all,

I've downloaded and installed: oracle-xe-univ-10.2.0.1-1.0.i386.rpm on Fedora 13 x86_64, using the following process:

Step # 1: Install Oracle 10g XE
# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

Step # 2: Configure the database
# /etc/init.d/oracle-xe configure

Specify the HTTP port that will be used for Oracle Application Express [8080]: (Enter for default)

Specify a port that will be used for the database listener [1521]: (Enter for default)

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM: *******
Confirm the password: *******

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]: (Enter for default)

Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"


Then I added the following to .bash_profile of user "userwork"
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
export ORACLE_SID=XE
export PATH=$PATH:$ORACLE_HOME/bin

================================================== ============================
I opened SQL*Plus, I tried to connect but I got the following error:

Code:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 16 19:17:53 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

I tried connecting from the Linux Terminal, but I get a Similar error:
Code:
[userwork@workst ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 17 00:03:21 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name: system
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified