- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: error when connecting Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 03:21 AM
тАО07-06-2004 03:21 AM
error when connecting Oracle
working on Oracle release 9.2.0.4.0(HP-UX 11.0), my collegue has a connection problem with this message:
ORA-12547: TNS:lost contact.
because i don't deal with it and he seems to be unable to resolve it, i'm asking your help.
thanks.
E.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 03:33 AM
тАО07-06-2004 03:33 AM
Re: error when connecting Oracle
His or the host tnsnames is not in 'sync.
Check and make sure you have the latest tnsnames.ora on your client...and that it is pointing correctly to the hosts Oracle.
Did anybody make a recent change in the hostfile or DNS ? Check this.
< I once made a simple change and didn't notice that an alias I added was on a line above the reference to my pkg name - was the same..oops...tns error >
Or did you have any disruption to your network ? Remember that Oracle listener can be fussy...folks attached may continue to work, but anyone who logs out will probably not be able to get back into Oracle - because the Oracle Listener is now out of sync with the database. Resolution - halt database, kill listener, cleanup resources (or reboot, whichever is quicker for ya) and restart your database & listener clean.
Just a couple things to check,
Rgrds,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 03:44 AM
тАО07-06-2004 03:44 AM
Re: error when connecting Oracle
the only thing i know is that they have installed patches for our Oracle version, but i don't know in what purpose.
i will check with him tomorrow.
but you have given me a beginning of answer, in my un-understanding of Oracle.. :-)
thanks.
E.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 06:20 AM
тАО07-06-2004 06:20 AM
Re: error when connecting Oracle
ps -ef | grep ora
This should should give something like (| cut -c 49-70 ):
ora_pmon_test
ora_dbw0_test
ora_lgwr_test
ora_ckpt_test
ora_smon_test
ora_reco_test
oracletest (DESCRIPTIO
oracletest (DESCRIPTIO
oracletest (DESCRIPTIO
That would be a handfull of oracle 'system' processes and here 3 'slaves' for instance 'test'.
If you don't see those first, then Oracle is not started. If you do see those last, then some folks can connect.
If Oracle is not running... try to start it:
su - oracle (or whatever name looks like oracle in /etc/passwd)
env | grep -i ora
sqlplus "/ as sysdba"
sql> startup
if that complains, check the error text and or tail the alert file:
find $ORACLE_HOME -name "alert*"
You should probably also have a listener active.
Check with 'lsnrctl status'.
If that mummble complaints, then tail the .log file is points to.
The listener is a unix process that looks like:
/oracle/xxxxx/bin/tnslsnr LISTENER
Good luck!
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 09:04 AM
тАО07-06-2004 09:04 AM
Re: error when connecting Oracle
output from ORA HELP:
oerr ORA 12547
12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.
as it was said, it can be many things. The fastes way how to solve it could be following:
check alert_db.log and try tnsping db (probably won't work, but...)
than check
tnsnames.ora and listener.ora
than
lsnsctl stop/start
than
log into oracle as sys or system and:
shutdown immediate
startup
post the results
br Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 08:12 PM
тАО07-06-2004 08:12 PM
Re: error when connecting Oracle
you should also have a look at the listerner.log and the alert.log for possible errors.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-06-2004 10:46 PM
тАО07-06-2004 10:46 PM
Re: error when connecting Oracle
I gave my collegue the whole informations.
apparently he has already checked most of it; and he is now checking the things he didnot think of....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2004 12:25 AM
тАО07-07-2004 12:25 AM
Re: error when connecting Oracle
Can you check the ping of your server, first by the hostname, check the ip adress,
after check the connect tring : tnsping ORACLE_SID;
check to your com port 1521 or 1526 and may be an other.
Do you use different database version on the same server
check the database is running good
check the following files :
tnsnames.ora
listener.ora
sqlnet.ora
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2004 12:38 AM
тАО07-07-2004 12:38 AM
Re: error when connecting Oracle
Can you move it in /tmp/trace for exmple and try to connect at you database maybe after a cycle shutdown and startup if is it possible
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2004 01:08 AM
тАО07-07-2004 01:08 AM
Re: error when connecting Oracle
Look at the tnsnames on the client machine. I've had this problem before and seems like I resolved it with an article from metalink.
When you connect, (the no trouble case) are you going through the network. sqlplus scott/tiger@oracle_service?
The sqlnet.ora file usually has an entry for a domain name. The domain name is appended to the service name in the tnsnames file and may not match the service name in the listener.ora file. If the server name is orcl and the host name is mydatabase.org, then the service name in the listener should be orcl.mydatabase.org.
In general, for most small installations I find the domain name a pain in the rear that I can do without. You can comment out the domain name in the sqlnet.ora on the client.
On the server, lsnrctl service will list the services that the listener is listening for. Compare these to the services in the tnsnames.ora file on the client.
If the ping works, try tnsping
ex: tnsping orcl
(where orcl is the service name)
This will ping the service in the listener. If you can't tnsping the listener, you have no prayer of connecting to the listener and the database.
Check metalink.oracle.com. I've had this problem before and I know I found the answer there. I'm just too old to remember it.
--Good Luck