logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 1 / 1
dagnachew
happy new year all
I have #
The listener supports no services
#
The command completed successfully which menas lnsrct is up but when I connect to db I get #
ERROR:
#
ORA-12547: TNS:lost contact
there are tons of people here none speaks
please
listener.ora I have HOST= localhost.localdomain my box hostname is myhost
what is this cold channel
anyone here please /
?
you know what
I was willing to pay but no one came forward
aurevoir
jesus christ
please help
I have already connected to oracle with lsncrtl . I am in fact in the lsnrctl > prompt
in another shell when I do sqlplys '/as sysdba' I get ERROR:
ORA-12547: TNS:lost contact
brianritchie, you there ?
TomJ, hello
hello ziyourenxiang
ziyourenxiang
hello dagnachew
dagnachew
ziyourenxiang, can you help me please
ziyourenxiang
dagnachew: possibly not, since i only lurk on this channel and don't run oracle in real life... but go ahead and ask your question, others who know the answer will respond
dagnachew
my lsncrtl starts fine . I start lsncrtl as user oracle , but when I do sqlplus '/as sysdba' I get Error ORA-12547: TNS:lost contact
ziyourenxiang, I doubt here one one speaks it's been 3 !!! yes three days am trying to setup oracle on my box
no one here beside 2 helped me Dormir and
ziyourenxiang
dagnachew: maybe it is because it is year-end and people are away
here's the first google hit on your error, hope it helps
http://www.dba-oracle.com/t_ora_12547_tns_lost_contact.htm
dagnachew
ziyourenxiang, bye
ziyourenxiang
bye
dagnachew
happy new year all
hello
usn
usn
         

usn
dagnachew, stop it
dagnachew
k
iam in lsnrctl prompt
when I try to connect sqlplus '/as sysdba I get error ora:12547
DiscordianUK
Are you still being a complete fool?
usn
an uninvited-private messaging fool as well :(
dagnachew
DiscordianUK, complete fool ?? are you stoopid or what ??? you can't answer the question leave it
same as you usn
usn
1) I can't see a question
2) I can't stand 10kB of query without talking first
dagnachew
usn excuse my words but am getting tired because in my #archchannel , #gentoo I ask question ii get this is not oracle , then knoow I get this foolishness common
DiscordianUK
You were in #fedora earlier , what distro are you actually using?
dagnachew
archlinux
DiscordianUK
Then wtf were you doing bothering us in #fedora, ?
usn
DiscordianUK, hey, stop ranting please
DiscordianUK
<rant off>
dagnachew
DiscordianUK, this for the last time . you can't answer just leave it ! otherwised you'rebeing immature !!!
DiscordianUK
(Action) chuckles
usn
dagnachew, is your environment set properly?
dagnachew
usn http://www.pastebin.ca/1734031
usn
can you please full copy-and-paste the command and the error message from prompt?
dagnachew
usn got it I think
as oracle user I wanted to open gedit and got no protocol
it's the display thingy
DiscordianUK
xhost + as the login user before su - oracle
usn
sqlplus does not need X
         

DiscordianUK
gedit does
usn
dagnachew, can you please full copy-and-paste the command and the error message from prompt?
dagnachew
ok
usn, http://www.pastebin.ca/1734036
usn
try the command like that:
sqlplus / as sysdba
mind the white spaces
connecting the DB this way does not need a listener in general, it works over IPC
dagnachew
same thing before I could get to the passord it's start with the error message
usn
c&p please
dagnachew
usn, http://www.pastebin.ca/1734042
usn
do you have an alert log from the database of that time?
dagnachew
usn, my files http://www.pastebin.ca/1734048
alert log let me check
where can I find alert.log ?
usn before I could connect with sqlplus but know I have the gui version of sqlplus with instant client
usn
$ORACLE_BASE/diag
dagnachew
usn, http://www.pastebin.ca/1734054
usn
pleas give me the txt version from trace directory under diag
xml is hard to read
dagnachew
usn my /etc/hosts http://www.pastebin.ca/1734060
usn, this listener.log http://www.pastebin.ca/1734065
usn
please give me the txt version (of alert log) from trace directory under diag
dagnachew
under that trace directory I have juste listener.log
TheBonsai
is the instance running?
dagnachew
TheBonsai, yes
TheBonsai, http://www.pastebin.ca/1734072
TheBonsai
is the instance running?
usn
:)
dagnachew
?
usn
listener != instance
TheBonsai
check if there are processes that contain 'pmon' in their name
dagnachew
TheBonsai, no process with pmon
TheBonsai, sqlplus gives me error
connection lost
usn
sqlplus should say: "Connected to an idle instance." That's your traget - without a password prompt of course.
dagnachew
usn, http://www.pastebin.ca/1734082
TheBonsai
ORACLE_SID, ORACLE_HOME, PATH - everything correct?
dagnachew
resolv.conf keeps being rewritten
sorry
echo PATH ..../data/oracle/product/11.2/bin
echo oracle_home /data/oracle and oracle_sid oradb
Xgc
dagnachew: Installing Oracle is not supposed to be this difficult. It shouldn't take a week to install. If the first correct attempt fails, you have run into either a bug in the installer or you aren't using an acceptable system with proper patches applied.
dagnachew
Xgc, I know but ai am using another distro
Xgc, I use archlinux , but am so close
Xgc
dagnachew: The "distro" you are using is likely not acceptable.
dagnachew
Xgc, to recap, I can start listener fine i can enter listner prompt fine
but when I want to start db instance sqlplus i get connection lost
am googling and it says to start oracle at boot
i won't do that
Xgc
or just give up and retry when you have the right platform or oracle supports your platform.
dagnachew
but I will to reboot after changing oratb lin e to Y
i will try
Xgc, usn, the thanks you again for your time,
TheBonsai, too
am very close i know
Xgc
It's one thing to have the necessary experience to attempt installation on non-supported platforms. It's quite another to attempt this without the necessary understanding.
dagnachew
even with oradb:/data/oracle/product/11.2:Y even with Y I can't connect
I have rebooted
I have the merit at least of having tried
i add in listener.ora SID_LIST_LISTENER = http://www.pastebin.ca/1734138
new lsnrctl start http://www.pastebin.ca/1734140
defaultro
good morning folks. Should ORACLE_UNQNAME point to the same value like our ORACLE_SID?
dagnachew
defaultr0, hello
Dormir
defaultro: no idea what that env variable is for
ah, something new for 11gR2
goyave
qqn qui parl;e francais ici ?
defaultro
hi Dormir, just got back
yep, it's for 11gr2. emctl start dbconsole is still failing
« prev next »