ORA-12514 when you change the ip address

1) Check/Modify the listener.ora like this:

 # listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

  # Generated by Oracle configuration tools.

SID_LIST_LISTENER =

    (SID_LIST =

      (SID_DESC =

        (PROGRAM = extproc)

        (SID_NAME = PLSExtProc)

        (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)

      )

      (SID_DESC =

      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)

   (SID_NAME = ORCL)

      )

    )

LISTENER =

    (DESCRIPTION_LIST =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

      )

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = W2K3V)(PORT = 1521))

      )

    )

---

2) In the comand prompt execute the following commands:

2.1) cd C:\oracle\product\10.2.0\db_1

2.2) sqlplus

then connect like sys as sysdba and run:

startup


3) Restart Oracle and the Tns Listener