-
Hello,
I have installed Oracle 9.0.1.0.0 on a Suse 7.2 and I can't get the listener
to start. I have checked on listener.ora and Tnsnames.ora they have the same
information, I checked and change /etc/services to include listener_name
and port 1521......
run dbastudio it comes back error message no listener, ORA-12541: TNS: no listener.
run dbstart, the database open, few seconds later I get
"Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0-production
with the partitioning option Jserver Release 9.0.1.0.0-production"
"Database "earth" warm started"
run lsnrctl start, I get
"message 1070 not found; no message file for prodct=network,
facility=TNSTNS=12545:message 12545 not found:.........."
Thanks,
mn
-
make sure that you have set the PATH correctly. then do
Code:
lsnrctl status
lsnrctl start
Sam
-
Usually Oracle has errors like this:
"message 1070 not found; no message file for prodct=network,
facility=TNSTNS=12545:message 12545 not found:.........."
when :
$ORACLE_HOME don't set or not set correctly.
-
No Listener
PATH is correct, it include $ORACLE_HOME
lsnrctl start see error message
Moderator, please remove dual topic. This is urgent I need some help
-
Can you try this?
Code:
cd $ORACLE_HOME/bin
./lsnrctl status <-- What did this return?
./lsnrctl start
What are the permissions on the listener.ora file and also if you don't mind could you post the listener.ora file. (make sure that you remove the IP/host addresses
Sam
-
No Listerner
Prem. on Listener.ora ( -rw-rw-r--)
. /lsnrctl status
"Message 1053 not found, No message file for product=network, facility=TNSTNS=12541:message 12541 not found; No message file for product=network, facility=TNSTNS-12560..........................."
Listener.ora ( File )
Listener =
(description_list =
(description =
(address_list =
(address=(protocol=ipc)(key=extproc))
)
(address_list=
(address=(protocal=tcp)(host=..........)(port=1521)
)
)
)
sid_list_listener=
(sid_list=
(sid_desc=
(sid_name = earth
(oracle_home= /home/mnaser/OraHome1)
(programe = extproc)
)
(sid_desc=
(global_dbname=earth)
(oracle_home= /home/mnaser/orahome1)
(sid_name= earth)
)
)
I have include the Path in the ".profile", I used the "PATH= "
and "export Path" commands to set the new path that included Oracle_home. Is this the correct command to update PATH in Linux?
-
Can you set
Code:
export ORACLE_HOME=/user/../app/oracle/product/...
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
As said on one of the earlier posts, its the problem with the environment setup. Reset the envioment and if you use the profile, then check to confirm that it got loaded correctly by
Else post your environment set up here
Sam
-
12545 is a TNSNAMES problem (host does not exist).
12560 says the adapter is not present.
If you are running locally, what are your BEQ protocol settings? (Again, in TNSNAMES.ORA).
I have also seen these errors when the networking protocol is not installed, which would also explain why the messages could not be found.
Is there a 'network' subdirectory in $ORACLE_HOME?
-
No Listener
Sam and others,
Sorry about this,
How to reset the enviorment?
What is the BEQ protocol, the only protocol listed in the TNSNAMES is (TCP)? and yes there is a "Network" subdirectory.
-
About ur environment:
It should be declare in ur .profile or .login or .bash_profile files,
depend from shell that u use.
How list ur environment variables:
> env
and u can see print like this:
NLS_LANG=american_america.we8iso8859p1
LD_LIBRARY_PATH=/opt/oracle/lib:/opt/home/sgene/perl/dbd/DBD-Oracle-1.06/blib/lib/auto/DBD/Oracle:/dbi/DBI-1.15/blib/arch/auto/DBI
PERL_HOME=/opt/home/sgene/perl
ORACLE_BASE=/opt/oracle
PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/opt/oracle/bin:/usr/bin:/etc:/bin:/opt/oracle/lib:/opt/home/sgene/perl/dbd/DBD-Oracle-1.06/blib/lib/auto/DBD/Oracle:/dbi/DBI-1.15/blib/arch/auto/DBI:/usr/local/ActivePerl-5.6/bin
DISPLAY=:0.0
DBI_LIB=dbi/DBI-1.15/blib/arch/auto/DBI
TNS_ADMIN=/opt/oracle/network/admin
DBD_LIB=dbd/DBD-Oracle-1.06/blib/lib/auto/DBD/Oracle
..
ORACLE_HOME=/opt/oracle/product/...
PATH=...:/opt/oracle/product/.../bin:...
CHECK :ORACLE_HOME, PATH ... other oracle variables
About error messages:
this messages may be if:
-- ORACLE_HOME=/opt/o... don't set correctly (not PATH=)
-- in $ORACLE_HOME/network/mesg u haven't *xx.msg files
where xx should be US for english language or another for language that set
in ur NLS_LANG= variable
---------------------------------------------
reset environment:
1 way :
logout
logon
2 way
su - oracle
---------------------------------------------
BEQ-LOCAL protocol this is especial oracle protocol between oracle
core software and client software on same box usually in nt(w2k) environment.
[Edited by Shestakov on 03-26-2002 at 06:11 PM]
-
No listener
The PATH in the Env. doesn't include the Oracle_home.
How to update the env and add it to .profile? and thanks for all your help. I'll post the result.
-
In your .profile say
ORACLE_HOME=/path until the product version
export ORACLE_HOME
PATH= $ORACLE_HOME/bin:$PATH
export PATH
LD_LIBRARY_PATH = $ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export LD_LIBRARY_PATH
eg:
ORACLE_HOME=/usr/local/oracle/app/oracle/product/9.0.1 <-- Directory under which you have installed the binary
export ORACLE_HOME
PATH = $ORACLE_HOME/bin:$PATH
export PATH
LD_LIBRARY_PATH = $ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export LD_LIBRARY_PATH
To get the changes activated, you got to logout and log in.
BTW, what is the shell you are using? If its bash, then there would be a bash profile, if it were to be c-shell, then you have to put the things in the .login file, with setenv
C - Shell
setenv ORACLE_HOME /binary installation path
setenv PATH $ORACLE_HOME/bin:$PATH
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:$ORACLE_HOME/network/lib
and do ./source
IF you still have problems, please post/send me your env setup and I can take a look into it.
Sam
-
No Listener
Sam,
I'm going to re-install, I can't find my binary at all.
My Oracle_Home Path doesn't have any product ver.
Thanks to everybody for the reply.
-
You will not find the product version in the directory path unless and otherwise you had mentioned it on the universal installer at the time of installation. :)
Sam