Home » Infrastructure » Linux » Oracle 10g installation
Oracle 10g installation [message #273932] Fri, 12 October 2007 04:56 Go to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
I am using linux on which i am trying to install orale 10g.
when i am trying to start the listener following error came
TNS-12537:TNS:connection closed
TNS-12560:TNS:protocol adapter error
TNS-00507:TNS:connection closed
Linux error:29 illegal seek


please help I tried to change host name from localhost.localdomain to "risl" but it did not worked pls help
Re: Oracle 10g installation [message #273936 is a reply to message #273932] Fri, 12 October 2007 05:02 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you set your ORACLE_HOME and ORACLE_SID variables?

Regards
Michel
Re: Oracle 10g installation [message #273938 is a reply to message #273936] Fri, 12 October 2007 05:06 Go to previous messageGo to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
I am new to oracle pls help me in setting
ORACLE_HOME and ORACLE_SID variables
Re: Oracle 10g installation [message #273943 is a reply to message #273936] Fri, 12 October 2007 05:34 Go to previous messageGo to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
yes i have set ORACLE_HOME = $ORACLE_BASE/PRODUCT/10gR2
ORACLE_SID =orcl


but I made some changes pls hence iwant to check ORACLE_HOME and ORACLE_SID variables please help how can i check these variables


Re: Oracle 10g installation [message #273950 is a reply to message #273943] Fri, 12 October 2007 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
env | grep ORACLE | sort

Regards
Michel
Re: Oracle 10g installation [message #274045 is a reply to message #273950] Sat, 13 October 2007 00:47 Go to previous messageGo to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
I checked my oracle home variable and it is set correctly however i could not find SID .
If both oracle home variable and SID both are correctly set.What further should I need to do to start up the listner so that;the above discussed errors are removed.
Re: Oracle 10g installation [message #274052 is a reply to message #274045] Sat, 13 October 2007 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you couldn't find SID then your variables are not correctly set.
Post the result of the command I asked.

Regards
Michel

[Updated on: Sat, 13 October 2007 02:22]

Report message to a moderator

Re: Oracle 10g installation [message #274057 is a reply to message #274052] Sat, 13 October 2007 04:03 Go to previous messageGo to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
I entered following $env|grep oracle|sort and results are following

$env|grep oracle|sort
GTK_RC_FILES=/etc/gtk/gtkrc:/opt/oracle/.gtkrc-1.2-gnome2
HOME=/opt/oracle
LOGNAME=oracle
MAIL=var/spool/mail/oracle
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/10gR2
PATH=/usr/kerberos/bin:opt/oracle/product/10gR2/bin:bin:/usr/bin:/usr/lcal/bin:usr/x11R6/bin
PWD=/opt/oracle
USER_NAME=oracle
Re: Oracle 10g installation [message #274058 is a reply to message #274057] Sat, 13 October 2007 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I asked ORACLE in UPPER case.
Can't you read? Can't you just make a copy and paste?

Regards
Michel
Re: Oracle 10g installation [message #274059 is a reply to message #274057] Sat, 13 October 2007 04:57 Go to previous messageGo to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
sorrry for mistake
Now i entered the correct command and results are
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/10gR2
ORACLE_SID=orcl
Re: Oracle 10g installation [message #274064 is a reply to message #274059] Sat, 13 October 2007 05:43 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"ps -eaf | grep smon"

Regards
Michel
Re: Oracle 10g installation [message #274071 is a reply to message #274059] Sat, 13 October 2007 06:31 Go to previous messageGo to next message
pdwivedi
Messages: 17
Registered: October 2007
Location: I
Junior Member
after entering ps -eaf | grep smon it gave

oracle 3231 3043 0 16:57 pts/0 00:00:00 grep smon
Re: Oracle 10g installation [message #274077 is a reply to message #274071] Sat, 13 October 2007 08:28 Go to previous message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have no database.
I'm not sure you correctly installed Oracle.
Why do you want to start a listener?

Regards
Michel

[Updated on: Sat, 13 October 2007 08:28]

Report message to a moderator

Previous Topic: TOAD on linux
Next Topic: Oracle server & client connection problem
Goto Forum:
  


Current Time: Tue Sep 02 00:26:17 CDT 2014

Total time taken to generate the page: 0.12687 seconds