You are currently browsing the archives for the Oracle category.
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Dec | ||||||
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 | |
- ESX Server (1)
- Installation (1)
- Linux (3)
- Mac World (5)
- MythTV (1)
- Oracle (1)
- PHP (1)
- Tools (1)
- 8. December 2009: How to Change Screenshot Format in Mac OS X
- 2. September 2009: Replace A String In The File Using Perl
- 31. August 2009: TNS-03505: Failed to resolve name
- 4. August 2009: How to login to VMware ESX Server 3i with SSH?
- 31. July 2009: My unqualified host name - Sendmail is slow
- 29. July 2009: How to install linux-header in Ubuntu
- 24. June 2009: Watch TV does not work - ERROR when trying to delete file
- 7. June 2009: How to enable error reporting in PHP?
- 7. January 2009: How to Flush DNS Cache in Mac OSX 10.5 Leopard?
- 8. October 2008: Software to Burn CD/DVD for Mac
Archive for the Oracle Category
TNS-03505: Failed to resolve name
31. August 2009 by VK.
If you are getting this error “TNS-03505: Failed to resolve name” in the Windows environment and you have checked sqlnet.ora and tnsnames.ora files then most likely it is becuase of the wrong environment variable settings.The best way to find which tnsping.exe you are running is “where” command.c:> where tnspingIt will show you if you are using a wrong tnsping.-Vigyan
Posted in Oracle | 3 Comments »
How to Install Oracle Database Client in MAC
15. September 2008 by VK.
Well, it is intersting getting familer with new tools that you have for Mac. The very first tool, I need to perform my job is the Oracle DB Client. The latest, version I could find for Mac is 10.1.0.3.
It is very easy to install Oracle client on Mac. Just download software from Oracle website http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/macsoft.html and unpack it in the directory where you want to have your ORACLE_HOME.
Oracle Database 10g Client Release 1 (10.1.0.3) for Apple Mac OS X
| ship_mac_client.cpio.gz (344,013,902 bytes) (cksum - 3052329470) |
Now, set the env in the .bash_profile and you are good to go.
ORACLE_HOME=/Users/vkaushik/Library/Oracle/10103/client/ohome; export ORACLE_HOME
DYLD_LIBRARY_PATH=$ORACLE_HOME/lib; export DYLD_LIBRARY_PATH
JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Home; export JAVA_HOME
PATH=$PATH:$ORACLE_HOME/bin; export PATH
Run the sqlplus.
-VK
Posted in Installation | No Comments »
Free - Oracle Database Performance Analyzer
16. October 2007 by VK.
I always think that there could be an easier method to parse AWR and Statspack report. Well, AWR report is in HTML format and easier to read then the txt output. In order to get the ifnromation that I am more interested in, I have written a parsor progran to parse the txt output from Statspack and AWR. I am sure this is not the perfact output a start to summarize the result.
If you may find bug in the tool as I have testing it against only few sample output of Statspack and AWR. Please let me know how I can improve this tool.
The URL for the tool is http://www.dbapool.com/analyzer/
-VK
Posted in Tools | No Comments »