-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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?
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|