| oracle10g - netmgr works but no tnsping [message #117041] |
Sat, 23 April 2005 14:05  |
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
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 #117134 is a reply to message #117041] |
Mon, 25 April 2005 06:22  |
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 #117169 is a reply to message #117163] |
Mon, 25 April 2005 09:57 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
