|
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
