6 Replies Latest reply: Aug 19, 2010 1:14 PM by EBSDBA RSS

    Installing oracle applications R12 in windows 2003

    EBSDBA
      Hi,
      I am trying to install oracle applications R12 on windows 2003. 32 bit. I followd the following steps but i receive
      TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor .
      The database created successfully, and the listener service as well. I can log in to sql on the same node.

      Log file shows:


      Connected to an idle instance.
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Disconnected
      Instance deleted.

      OPW-00005: File with same name exists - please delete or rename
      Instance created.

      SQL*Plus: Release 11.1.0.7.0 - Production on Thu Aug 19 15:29:13 2010

      Copyright (c) 1982, 2008, Oracle. All rights reserved.

      Connected to an idle instance.
      ORACLE instance shut down.
      Connected to an idle instance.
      ORACLE instance started.

      Total System Global Area 1071333376 bytes
      Fixed Size          1352100 bytes
      Variable Size          427822684 bytes
      Database Buffers     629145600 bytes
      Redo Buffers          13012992 bytes

      Control file created.


      Database altered.


      Tablespace altered.


      Tablespace altered.


      Tablespace altered.


      Tablespace altered.


      Database altered.

      Database closed.
      Database dismounted.
      ORACLE instance shut down.
      Connected to an idle instance.
      ORACLE instance started.

      Total System Global Area 1071333376 bytes
      Fixed Size          1352100 bytes
      Variable Size          427822684 bytes
      Database Buffers     629145600 bytes
      Redo Buffers          13012992 bytes
      Database mounted.

      PL/SQL procedure successfully completed.

      ORACLE instance shut down.
      Connected to an idle instance.
      ORACLE instance started.

      Total System Global Area 1071333376 bytes
      Fixed Size          1352100 bytes
      Variable Size          427822684 bytes
      Database Buffers     629145600 bytes
      Redo Buffers          13012992 bytes

      Control file created.


      Database altered.


      Tablespace altered.


      Tablespace altered.


      Tablespace altered.


      Tablespace altered.


      Database altered.


      PL/SQL procedure successfully completed.

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ECHO is off.
      Checking for errors ...
      ECHO is off.
      adcrdb.cmd exiting with status 0

      .end std out.

      .end err out.


      ---------------------------------------------------------------
      ADX Database Utility
      ---------------------------------------------------------------

      getConnectionUsingAppsJDBCConnector() -->
      APPS_JDBC_URL='null'
      Trying to get connection using SID based connect descriptor
      getConnection() -->
      sDbHost : erpserv
      sDbDomain : oracle.com
      sDbPort : 1521
      sDbSid : VIS
      sDbUser : APPS
      Trying to connect using SID...
      getConnectionUsingSID() -->
      JDBC URL: jdbc:oracle:thin:@erpserv.oracle.com:1521:VIS
      Exception occurred: java.sql.SQLException: Locale not recognized
      Trying to connect using SID as ServiceName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserv.oracle.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS)))
      Exception occurred: java.sql.SQLException: Locale not recognized
      Trying to connect using SID as ServiceName.DomainName
      getConnectionUsingServiceName() -->
      JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserv.oracle.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS.oracle.com)))
      Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
      The Connection descriptor used by the client was:
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserv.oracle.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS.oracle.com)))

      Connection could not be obtained; returning null

      -------------------ADX Database Utility Finished---------------

      RC-00118: Error occurred during creation of database
      Raised by oracle.apps.ad.clone.ApplyDatabase


      It is failing in stage 2.

      I can successfully do tnsping with the same string.

      1). Installed loop back adapter and ip address 10.10.10.10
      I can ping with this address and FQDN. But when i right click this loop back adapter and check status, received Packets is zero. Is this the problem. More over i am installing it as administrator user.

      I can ping on 10.10.10.10 and also hostname,FQDN

      I installed the whole MS Visual 2005. So there are many folders like sqlserver, VB, VC#, VC ...... So i have choosen VC.

      Regards
      Taher