Wednesday 30 October 2013

test2


If you change oracle machine host name, the listener can’t run due to error in configuration.
So you need to configure it again manually as:

  1. Stop Database Listener and Service
  2. Go to installation directory
  3. Navigate:
    • 
      “\app\oracle\product\<oracle version>\server\NETWORK\ADMIN”
  4. Edit:“listener.ora
    • 
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = <new_host_name>)(PORT = 1521))
      )
      )
      
  5. Edit:“tnsnames.ora
    • XE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =<new_host_name>(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
      )
      )
      
  6. Start the Listener and Service again

test

...Your html-escaped code goes here...
    echo "I like PHP";