Ask the Expert

Error with tnsping test

I have two Oracle databases, one located in my PC named test, the other located on the server named mydb. Normally, when I use "tnsping test" and "tnsping mydb" at both PC and server, the results I get are ok. One day, the server was down due to a power supply problem, and when it restarted again, I only had to issue "startup open" to startup the database, and it seemed to work well. But at the server, when I issued "tnsping test" to ping the database at my PC) and "tnsping mydb" (to ping itself), the following error occured:
/
 [oracle@thunghiem oracle]$ tnsping test
 TNS Ping Utility for Linux: Version 9.2.0.1.0 -
 Production on 16-OCT-2002
 07:47:50
 Copyright (c) 1997 Oracle Corporation.  All rights
 reserved.
 Segmentation fault /
On the contrary, when I tnsping from my PC to the server, the result is ok! Could you please guide me to the solution?

    Requires Free Membership to View

When your server crashed, it is possible that some library files or executables became corrupt. Did you run a file system check after the server was rebooted? It sounds like you might want to reinstall the Oracle software and recompile the binary executables. This should fix your segmentation fault problem.

For More Information


This was first published in October 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: