Home » Infrastructure » Linux » oracle10g - netmgr works but no tnsping
oracle10g - netmgr works but no tnsping [message #117041] Sat, 23 April 2005 14:05 Go to next message
zord
Messages: 6
Registered: April 2005
Junior Member
Hi,
I'm trying to install oracle db 10g on linux (Suse 9.1) for three days now, but can't get it to work.

The installation actually worked fine, once all variables and kernel parameters were set.
I created a database called train. Tests in netmgr are successfull for scott/tiger and the system account.
I can connect via 'sqlplus system/password'.
But 'sqlplus system/password@train' or 'sqlplus system/password@train.mydomain.net' won't work at first. I have to reenter the username and password.
oracle@linux:~> sqlplus system/password@train
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: system
Enter password:
Connected to:
Oracle Database 10g Release 10.1.0.3.0 - Production
SQL>

Also 'tnsping train' or 'tnsping train.mydomain.com ain't succesfull:
oracle@linux:~> tnsping train
Used parameter files:
/compiere/app/oracle/OraHome_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
oracle@linux:~>


To start the db i use 'lsnrctl start' and startup via sqlplus connected to / as sysdba.

I need to be able to connect via 'sqlplus system/password@train', because the Compiere install script trys to do it that way.

Has anybody any idea what I could do?
Did I forget configuring anything, or what could be the matter?
Any help is apreciated, thx alot.

These are my config files (oracle_sid=train, host=linux, domain=huberei.net):
oracle's bash_profile:
umask 022
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
export DISPLAY=:0.0
export ORACLE_BASE=/compiere/app/oracle
export ORACLE_HOME=$ORACLE_BASE/OraHome_1
export ORACLE_SID=train
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib:$ORACLE_HOME/lib
My sysctl.conf:
kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
vm.disable_cap_mlock = 1

My listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /compiere/app/oracle/OraHome_1)
      (PROGRAM = extproc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linux.huberei.net)(PORT = 1521))
    )
  )

My sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
NAMES.DEFAULT_DOMAIN = huberei.net

and the tnsnames.ora
# Generated by Oracle configuration tools.
 
TRAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linux.huberei.net)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = train)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
Re: oracle10g - netmgr works but no tnsping [message #117072 is a reply to message #117041] Sun, 24 April 2005 10:08 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

Try changing default domain in sqlnet.ora to linux.huberei.net.

Regds
Girish
Re: oracle10g - netmgr works but no tnsping [message #117077 is a reply to message #117072] Sun, 24 April 2005 10:58 Go to previous messageGo to next message
zord
Messages: 6
Registered: April 2005
Junior Member
Hi,
thanks for the advice, but it doesn't help. Sad
Still the same behaviour, netmgr works, but no tnsping and no "sqlplus system/password@train".

Regards
Re: oracle10g - netmgr works but no tnsping [message #117134 is a reply to message #117041] Mon, 25 April 2005 06:22 Go to previous messageGo to next message
zord
Messages: 6
Registered: April 2005
Junior Member
Hi,

Is this maybe some problem with the listener?
Shouldn't this say something about train?
Output of 'lsnrctl start':
oracle@linux:/compiere/app/oracle/OraHome_1/network/admin> lsnrctl start
                                                                                                  
LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 25-APR-2005 12:11:45
                                                                                                  
Copyright (c) 1991, 2004, Oracle.  All rights reserved.
                                                                                                  
Starting /compiere/app/oracle/OraHome_1/bin/tnslsnr: please wait...
                                                                                                  
TNSLSNR for Linux: Version 10.1.0.3.0 - Production
System parameter file is /compiere/app/oracle/OraHome_1/network/admin/listener.ora
Log messages written to /compiere/app/oracle/OraHome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux.huberei.net)(PORT=1521)))
                                                                                                  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date                25-APR-2005 12:11:45
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /compiere/app/oracle/OraHome_1/network/admin/listener.ora
Listener Log File         /compiere/app/oracle/OraHome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux.huberei.net)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@linux:/compiere/app/oracle/OraHome_1/network/admin>


Thanks
Re: oracle10g - netmgr works but no tnsping [message #117163 is a reply to message #117134] Mon, 25 April 2005 09:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Shouldn't this say something about train?
It should
you have not configured the listener LISTENER to listen for instance TRAIN.
Your listener.ora should be something like ( replace with right values).
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /compiere/app/oracle/OraHome_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
    (ORACLE_HOME = youroraclehome)
    (SID_NAME = yourSID)
    )

  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linux.huberei.net)(PORT = 1521))
    )
  )
Re: oracle10g - netmgr works but no tnsping [message #117169 is a reply to message #117163] Mon, 25 April 2005 09:57 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

In listener.ora pls configure the parameter ADDRESS_LIST.

eg entry is like this:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))
)
)
)

REgds
Girish
Re: oracle10g - netmgr works but no tnsping [message #117173 is a reply to message #117041] Mon, 25 April 2005 10:26 Go to previous messageGo to next message
zord
Messages: 6
Registered: April 2005
Junior Member
Hi,
@Mahesh Rajendran:
I did that, but it's still the same.
Thanks anyways.

I uploaded listener.trc and listener.log, but I didn't find any errormessages.
http://www.cs.fhm.edu/~ifw03064/listener.log
http://www.cs.fhm.edu/~ifw03064/listener.trc

Any other ideas what could be wrong?

@girish: on my way trying that, thanks Wink

[Updated on: Mon, 25 April 2005 10:28]

Report message to a moderator

Re: oracle10g - netmgr works but no tnsping [message #117174 is a reply to message #117173] Mon, 25 April 2005 10:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First ping the host. it should be good.
Then make sure listener is UP. else start the listener.

$lsnrctl start

then comment of all entries in sqlnet.ora in serverside.
try tnsping.
Tnsping check the availablity of listener.
DOes not gurantee that the database is up.
then try sqlplus.

look into sqlnet.log
Re: oracle10g - netmgr works but no tnsping [message #117181 is a reply to message #117041] Mon, 25 April 2005 11:03 Go to previous messageGo to next message
zord
Messages: 6
Registered: April 2005
Junior Member
@Girish: Same situation as before :/

@Mahesh Rajendran:
I can ping the host (localhost).
But tnsping already fails.
sqlplus can't conntect to train.
Re: oracle10g - netmgr works but no tnsping [message #117184 is a reply to message #117181] Mon, 25 April 2005 11:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you comment of all entries in sqlnet.ora.
try it.
and POST The relevant entries in sqlnet.log
Re: oracle10g - netmgr works but no tnsping [message #117194 is a reply to message #117041] Mon, 25 April 2005 12:27 Go to previous message
zord
Messages: 6
Registered: April 2005
Junior Member
It's workin Very Happy
I had to uncomment 'NAMES.DEFAULT_DOMAIN = linux.huberei.net'.
Now everything works.
Compiere is installed and workin.

Thank you very much, guys.
Previous Topic: Help needed with Shell script !!
Next Topic: can't install on FedraCore3, warning :Cannot convert string...
Goto Forum:
  


Current Time: Tue Feb 07 05:58:15 CST 2023