View previous topic :: View next topic |
Author |
Message |
misterLu Guru
Joined: 14 Sep 2003 Posts: 430 Location: Poland
|
Posted: Wed Sep 28, 2005 4:03 pm Post subject: can't start Oracle 10 |
|
|
I've installed Oracle 10g,
Now I have a problem with basic configuration and starting the oracle server.
My location of Oracle is:
Code: | $ set | grep ORACLE
ORACLE_BASE=/home/ludwik/oracle
ORACLE_HOME=/home/ludwik/oracle/product/10.2.0/db_4/
ORACLE_SID=dark
|
In the directory:
"/home/ludwik/oracle/product/10.2.0/db_4/network/admin/"
i've placed the tnsnames.ora and listener.ora files.
listener.ora:
Code: | LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=lu)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
)
|
and tnsnames.ora
Code: |
LU.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LU.WORLD)
)
)
|
I can start listener
Code: |
$ bin/lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-SEP-2005 17:41:34
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/ludwik/oracle/product/10.2.0/db_4//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/ludwik/oracle/product/10.2.0/db_4/network/admin/listener.ora
Log messages written to /home/ludwik/oracle/product/10.2.0/db_4/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lu)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 28-SEP-2005 17:41:34
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/ludwik/oracle/product/10.2.0/db_4/network/admin/listener.ora
Listener Log File /home/ludwik/oracle/product/10.2.0/db_4/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lu)(PORT=1521)))
The listener supports no services
The command completed successfully
|
However it seems that the listener doesn't read "/home/ludwik/oracle/product/10.2.0/db_4/network/admin/listener.ora",
because when I set in listener.ora hostname to "xxxx" or whatever, the listener still starts with the same message (above).
Where should I place tnsnames.ora and listener.ora files ?
What else should I start to get Oracle server up? |
|
Back to top |
|
|
thrope n00b
Joined: 03 Nov 2004 Posts: 66
|
Posted: Wed Sep 28, 2005 9:05 pm Post subject: |
|
|
First, the listener is seperate to the database.
To check the database is working try connecting locally.
make sure ORACLE_HOME and ORACLE_SID are set and connect with
# sqlplus / as sysdba
You should then be able to startup and shutdown the database.
If that works then it is just the listener that has the problem.
It looks to me like your listener is starting ok, but since you are not specifying a SID directly in the listener, the database has to register itself with the datbase. This should be done every 60 seconds, but I find it sometimes takes longer. If you're impatient and want to make sure it's working connect locally again.
#sqlplus / as sysdba
SQL> alter database register
You should then be able to connect through the lsitener...
#sqlplus user/password@LU.WORLD
If that still doesn't work I'd suggest some changes:
try IP numbers instead of hostname in both files, explicitly register the SID in the listener, and add a SID (in addition to or instead of the SERVICE) in the TNSNAMES.
My files (for a simple non-RAC database; also 10.1 but I dont think there smuch difference) would look like
listener.ora:
Code: |
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /home/ludwik/oracle/product/10.2.0/db_4/)
(SID_NAME = dark)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lu)(PORT = 1521))
)
)
)
|
tnsnames.ora:
Code: |
lu_dark =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lu)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dark)
)
)
|
Also these files are very sensitive to extra characters, make sure there are no tabs or anything, type it out again if need be...
Hope this helps
thrope
ps you really only need the listener if you're running clients over a network, otherwise you can do everything through the local BEQUEATH connection. |
|
Back to top |
|
|
misterLu Guru
Joined: 14 Sep 2003 Posts: 430 Location: Poland
|
Posted: Wed Sep 28, 2005 9:34 pm Post subject: |
|
|
I've followed Your instructions:
I've updated my tnsnames.ora and listener.ora.
I've also emerged libaio.
Code: |
$ export ORACLE_BASE=/home/ludwik/oracle
$ export ORACLE_HOME=/home/ludwik/oracle/product/10.2.0/db_4/
$ export ORACLE_SID=darkser-name:
$ set | grep ORACLE
ORACLE_BASE=/home/ludwik/oracle
ORACLE_HOME=/home/ludwik/oracle/product/10.2.0/db_4/
ORACLE_SID=dark
_=ORACLE_SID
ludwik@lu ~/oracle/product/10.2.0/db_4 $ bin/sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 28 23:22:09 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
oracledark: /usr/lib/libaio.so.1: version `LIBAIO_0.4' not found (required by oracledark)
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
|
I tried to find something about it, but I failed.
May be the problem caused by my gcc version?
Code: | # gcc --version
gcc (GCC) 3.3.4 20040623 (Gentoo Linux 3.3.4-r1, ssp-3.3.2-2, pie-8.7.6)
|
I've read that gcc should be 2.9.5 to get Oracle working. Is that true ? |
|
Back to top |
|
|
tranquilcool Veteran
Joined: 25 Mar 2005 Posts: 1179
|
Posted: Sat Oct 15, 2005 7:56 am Post subject: |
|
|
you don't need gcc-2.9.5 to get oracle working.
it might be a libaio problem. the gentoo libaio you emerged doesn't work.
to get libaio working do the following;
cd ~/
-wget "ftp://ftp.suse.com/pub/suse/i386/9.1/suse/src/libaio-0.3.102.src.rpm"
-rpm2targz libaio-0.3.102.src.rpm
-tar zxf libaio-0.3.102.src.tar.gz
-tar jxf libaio-0.3.102.tar.bz2
-cd libaio-0.3.102
-make
-make install
hope this helps. _________________ this is a strange strange world. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|