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:
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 specifiedI tried connecting from the Linux terminal but I get a similar error:
[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