Home > Ask the Oracle Experts > (Archive) Database Installation and Upgrade Questions & Answers > Accessing the Oracle 9i database
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Accessing the Oracle 9i database

Dan Norris EXPERT RESPONSE FROM: Dan Norris

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 14 January 2005
I am trying to access the database of Oracle 9i installed on a Unix server True64. I installed DBA studio on my computer and I added in the database tree -- the database that I want to access is OK. When I enter the user name and password to connect with the database,an error, "Ora 12541 :NO LISTENER" appears. I checked the listener.ora and it's OK.

>
EXPERT RESPONSE
Sounds like what you added to your local configuration and your real destination don't match. From your PC, I'd go to a command prompt (because that's how I am) and use Oracle's tnsping utility to "tnsping " and see where the alias tries to contact.

If your Tru64 system is part of a cluster, then your listener may be listening on a floating IP address. If that's the case, then check your listener.ora file on the server and make sure that the ADDRESS part of the listener.ora is the same as the ADDRESS part in your tnsnames.ora on your PC.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
(Archive) Database Installation and Upgrade
Starting database automatically
Database Upgrade Assistant error
9.2 versus 9i
Empty error dialog window from the Database Configuration Assistant after install
Looking for 8.1.7 as stepping stone to 9.2
Command-line installation of 8.1.7?
Oracle 10g migration guide
Oracle 7.0 vs. higher Oracle versions
Export and import
Oracle migration problem

Oracle database installation, upgrades and patches
Intermap details its Oracle database 11g upgrade
Oracle OpenWorld 2008 Special Report
Oracle extends Real Application Testing to 10g, 9i
Third-party Oracle database tools remain an attractive option
Enterprise search a key component of Oracle portal project
Oracle Enterprise Manager leverages multiple environments for pharmaceutical giant
Oracle 11g upgrade veteran offers step-by-step advice
Oracle Database 11g gets early use at Burlington Coat Factory
Oracle database upgrades require soul searching
With software upgrades, pain leads to gain

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts