OraFAQ Forum: Server Administration » Oracle XE problem. Can't create user and ORA-01034: ORACLE not available.

Home » RDBMS Server » Server Administration » Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. (Linux - Fedora 8 (32 Bit version))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470283]

Mon, 09 August 2010 08:32

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

Hi All, i'm a newbie to Oracle XE. I want to use oracle XE for application integration purpose i need oracle working desperately. I installed oracle oracle-xe-univ-10.2.0.1-1.0.i386.rpm onto my production server. I got installed. The problem is after logging into the oracle XE i couldn't create user when i try to do that it's barfing. Please take a look at the screen shots below. Then you can understand the complete tragedy what i'm facing. I'm surprised because i used this same oracle version in other production server before 2 months but now it's barfing. Please help me out folks. I googled in web but i couldn't figure out what's the exact problem. Oracle service is running and it's a fresh installation and fresh server too.I added the link of my screen shot for further reference.

Attachment: 2.JPG
(Size: 37.17KB, Downloaded 886 times)

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470288 is a reply to message #470283]

Mon, 09 August 2010 08:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Your database is down
or
You have a wrong ORACLE_SID defined.

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470448 is a reply to message #470288]

Tue, 10 August 2010 00:43

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

I can't agree your solution mahesh. Please check the screen shot below in the attachment.Database is running and i had set a environmental variable correctly but still it's barfing the same.

Attachment: 3.JPG
(Size: 127.47KB, Downloaded 768 times)

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470461 is a reply to message #470448]

Tue, 10 August 2010 01:19

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Note that some of us can't or don't want to download files and so can't answer you.
Copy and paste your session as TEXT inside the post, you do not need any image.

Regards
Michel

[Updated on: Tue, 10 August 2010 01:19]

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470474 is a reply to message #470461]

Tue, 10 August 2010 01:46

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

Yep sure will post!

Output:

~]# service oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 10-AUG-2010 12:12:16

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 09-AUG-2010 16:36:30
Uptime 0 days 19 hr. 35 min. 46 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=ip-10-224-103-113.eu-west-1.compute.internal)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
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 READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully

~]# echo $ORACLE_SID
XE

~]# sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 10 12:15:08 2010

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

Enter password:
Connected to an idle instance.

SQL> create user test;
create user test
*
ERROR at line 1:
ORA-01034: ORACLE not available

SQL>

Prior to the last post mahesh has pointed out my database has gone down either SID has set to wrong. Please find the above output to know what has happened with my server.

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470482 is a reply to message #470474]

Tue, 10 August 2010 01:59

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Connected to an idle instance.

The database is not started.

Quote:

echo $ORACLE_SID

Post "env | grep ORACLE_SID"

Regards
Michel

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470581 is a reply to message #470482]

Tue, 10 August 2010 04:34

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

This is the output i got when i try with the command "env | grep ORACLE_SID"

Quote:

~]# env | grep ORACLE_SID
ORACLE_SID=XE

I already displayed that the services are running. Then how come we can say that database is not running. I have one more doubt, which is pertained to this i suspect this might be the cause for the problem. This system has only 1.7 gb of RAM. So, that oracle doesn't like that cos oracle requests more shared memory i believe.

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470584 is a reply to message #470581]

Tue, 10 August 2010 04:38

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I forgot, also "env | grep ORACLE_HOME" and "env | grep LOCAL"... well, better do it in a whole: "env | sort".

Regards
Michel

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470590 is a reply to message #470584]

Tue, 10 August 2010 04:50

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

Quote:

~]# env | sort
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/root
HOSTNAME=ip-10-225-104-115
INPUTRC=/etc/inputrc
JAVA_HOME=/usr/local/java/jdk1.6.0_10
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=root
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.svgz=00;31:*.arj=00;31:*.taz=00;31:* .lzh=00;31:*.lzma=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.dz=00;31:*.gz=00;31:*.bz2=00;31:*.tbz2=00;31:*.bz=00;31:*.tz=00;31:*.deb=00 ;31:*.rpm=00;31:*.jar=00;31:*.rar=00;31:*.ace=00;31:*.zoo=00;31:*.cpio=00;31:*.7z=00;31:*.rz=00;31:*.jpg=00;35:*.jpeg=00;35:*.gif=00; 35:*.bmp=00;35:*.pbm=00;35:*.pgm=00;35:*.ppm=00;35:*.tga=00;35:*.xbm=00;35:*.xpm=00;35:*.tif=00;35:*.tiff=00;35:*.png=00;35:*.mng=00; 35:*.pcx=00;35:*.mov=00;35:*.mpg=00;35:*.mpeg=00;35:*.m2v=00;35:*.mkv=00;35:*.ogm=00;35:*.mp4=00;35:*.m4v=00;35:*.mp4v=00;35:*.vob=00 ;35:*.qt=00;35:*.nuv=00;35:*.wmv=00;35:*.asf=00;35:*.rm=00;35:*.rmvb=00;35:*.flc=00;35:*.avi=00;35:*.fli=00;35:*.gl=00;35:*.dl=00;35: *.xcf=00;35:*.xwd=00;35:*.yuv=00;35:*.svg=00;35:
MAIL=/var/spool/mail/root
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
ORACLE_SID=XE
PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/java/jdk1.6.0_10/bi n:/root/bin:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/
PWD=/root
SHELL=/bin/bash
SHLVL=1
SSH_CLIENT=<someipaddress> 4928 22
SSH_CONNECTION=<someipaddress> 4928 <someipaddress> 22
SSH_TTY=/dev/pts/0
TERM=xterm
USER=root
_=/bin/env

[Updated on: Tue, 10 August 2010 04:51]

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470613 is a reply to message #470590]

Tue, 10 August 2010 05:41

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And you try to connect from the server containing XE instance and not remotely?

Regards
Michel

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470646 is a reply to message #470613]

Tue, 10 August 2010 06:47

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

Actually it's a amazon server(UK). I'm using putty tool to connect server.I'm in india.

[Updated on: Tue, 10 August 2010 06:47]

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470687 is a reply to message #470646]

Tue, 10 August 2010 08:01

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you in the server of the database you're trying to connect?

Regards
Michel

Report message to a moderator

Re: Oracle XE problem. Can't create user and ORA-01034: ORACLE not available. [message #470694 is a reply to message #470687]

Tue, 10 August 2010 08:37

vij223
Messages: 7
Registered: August 2010
Location: Bangalore, India

Junior Member

yes. I installed the database in that server only. I'm trying to login into that server using putty and i tried to create a new user.It's failing with oracle not available.

Report message to a moderator

Previous Topic:	DBMS_JOB restarting
Next Topic:	Connect 500+ client to romote oracle server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 21:58:02 CDT 2024