Home » Infrastructure » Linux » install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5
install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343167] Tue, 26 August 2008 09:09 Go to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
hello all,

I have a probleme with oracle

I do :

pwd
/etc/init.d

./oracle-xe configure
Oracle Database 10g Express Edition is already configured

./oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-AUG-2008 15:41:50

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                26-AUG-2008 15:10:44
Uptime                    0 days 0 hr. 31 min. 6 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhos.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
  Instance "XE", status BLOCKED, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
  Instance "XE", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

it's ok ?




with : sqlplus

 sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 26 15:43:14 2008

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

Enter user-name: sys
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

or 

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges



What can I do?


thank you for your help

Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343501 is a reply to message #343167] Wed, 27 August 2008 07:40 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
Sad someone?
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343523 is a reply to message #343501] Wed, 27 August 2008 08:16 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
ORA-01033: ORACLE initialization or shutdown in progress


Restart the database.

If it doesn't start look for errors in the alert.log.
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343528 is a reply to message #343167] Wed, 27 August 2008 08:23 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
service oracle-xe stop
Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

[root@srv56 ~]# service oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.


[root@APP-SPARE ~]# updatedb
loca[root@APP-SPARE ~]# locate alert.log

Sad
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343535 is a reply to message #343528] Wed, 27 August 2008 08:32 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
So is there still a problem or not?

Can you connect now or not?

/forum/fa/1620/0/

The alert.log is in the background dump directory, which is configurable so I can't tell you where it is. Probably a "bdump" directory somewhere below /usr/lib/oracle/xe/app/oracle/product/




Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343536 is a reply to message #343167] Wed, 27 August 2008 08:37 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
thanks for your help

has my opinion there is no database after the installation is that's why I have problems

where is the directory of database ?
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343539 is a reply to message #343167] Wed, 27 August 2008 08:39 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mer. Aot 27 15:14:33 2008

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

Entrez le nom utilisateur : SYS
Entrez le mot de passe :
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Entrez le nom utilisateur : sys
Entrez le mot de passe :
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Entrez le nom utilisateur :
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343545 is a reply to message #343539] Wed, 27 August 2008 08:48 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
A oracle database doesn't have a directory.

Follow the instructions to the letter.

According to those instructions the database creation logs should be in $ORACLE_HOME/config/log/*.

Also, the way to log in as sysdba when the database is down is :

sqlplus "/ as sysdba"
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343549 is a reply to message #343167] Wed, 27 August 2008 08:54 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
[migi@srv56 server]$ pwd
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[migi@srv56 server]$ find . -name *.log
./config/log/postScripts.log
./config/log/postDBCreation.log
./config/log/CloneRmanRestore.log
./config/log/cloneDBCreation.log
./network/log/listener.log
./log/srv56/client/css.log
[migi@srv56 server]$


what are the log interesting for my problem ?

[migi@srv56 server]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mer. Aot 27 15:29:04 2008

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

ERROR:
ORA-12705: Impossible d'accder aux fichiers de donnes NLS ou environnement
indiqu non valide


Entrez le nom utilisateur : sysdba
Entrez le mot de passe :
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


Entrez le nom utilisateur : sys
Entrez le mot de passe :
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


SP2-0157: impossible de se CONNECTER  ORACLE aprs 3 essais, sortie de SQL*Plus
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #343551 is a reply to message #343549] Wed, 27 August 2008 09:03 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

what are the log interesting for my problem ?



Possibly all of them.

Quote:

ORA-12705: Impossible d'accder aux fichiers de donnes NLS ou environnement
indiqu non valide



The user environment is not set-up correctly.

So you most likely didn't do 4.3 Setting the Oracle Database XE Server Environment Variables

Just follow the instructions to the letter.
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #344245 is a reply to message #343167] Fri, 29 August 2008 03:31 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member

I reinstalled it with the documentation and i have this :

[root@srv56 bin]# sqlplus system

SQL*Plus: Release 10.2.0.1.0 - Production on Ven. Août 29 10:04:00 2008

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

Entrez le mot de passe :
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory


Entrez le nom utilisateur :
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #344251 is a reply to message #343167] Fri, 29 August 2008 04:01 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
I change /etc/oratab

XE:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server:Y



service oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 29-AUG-2008 10:27:36

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                29-AUG-2008 10:27:32
Uptime                    0 days 0 hr. 0 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #344740 is a reply to message #344251] Mon, 01 September 2008 02:39 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
up Sad
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #354034 is a reply to message #343167] Thu, 16 October 2008 03:11 Go to previous messageGo to next message
gangan
Messages: 10
Registered: August 2008
Location: paris
Junior Member
hello,

I reinstalled on another pc and always impossible to connect this

sqlplus system/password@XE

SQL*Plus: Release 10.2.0.1.0 - Production on Jeu. Oct. 16 09:58:45 2008

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

ERROR:
ORA-12154: TNS : l'identificateur de connexion indiqu n'a pas pu tre rsolu


Entrez le nom utilisateur :


sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Jeu. Oct. 16 09:59:29 2008

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

ERROR:
ORA-12545: Connexion impossible car l'hte ou l'objet cible n'existe pas


Entrez le nom utilisateur :



sqlplus system

SQL*Plus: Release 10.2.0.1.0 - Production on Jeu. Oct. 16 09:59:59 2008

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

Entrez le mot de passe :
ERROR:
ORA-12545: Connexion impossible car l'hte ou l'objet cible n'existe pas


any idea ?
Re: install oracle-xe-10.2.0.1-1.0.i386.rpm in rhel 5 [message #354038 is a reply to message #354034] Thu, 16 October 2008 03:19 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Unset TWO_TASKS.

Regards
Michel
Previous Topic: shell script
Next Topic: 11G installer hangs
Goto Forum:
  


Current Time: Fri Mar 29 00:13:37 CDT 2024