Monday, May 14, 2012

Oracle 11g How-to Set the Listener Parameters File

In this Post will be Treated How-to Set the Oracle 11g Parameters File to Overcome Set-Up Database Troubles.
This is a About a Troubleshooting for an Error in Oracle 11g Database Creation Manifested by the Message "Oracle 11g listener is not up or database service is not registered with it".

  1. Open a Terminal Window
  2. Start by Restarting the Listener and Finding the Listener File Path with:
    lsnrctl stop
    lsnrctl start <listenerName>
    In the Output Find the Line Containing the Listener Parameter File Path
    Copy the Listener Parameter File Path.
  3. Edit the Parameter File:
    nano <path/To/parameterFile>
    Find and Change the HOSTNAME

    On Localhost for Example Try to Switch between:

    • 127.0.0.1
    • localhost.localdomain

  4. Now Restart Again the Listener like Above.
Now you Can Try to Re-Executing the Listener to Database Set-Up for Oracle 11g Database.
Here the Guide to Association Database-Listener:
Joomla Website Development

Oracle Database, Oracle Database, Oracle Database

Drupal Website Development

No comments:

Post a Comment