2 Replies Latest reply: Jan 9, 2013 4:05 AM by 838196 RSS

    ApexListener 2.0 configured with service name but SQLDeveloper says SID

    838196
      Hi,
      I've configured the ApexListener 2.0.0.354.17.05 via command line interface as described in http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/install.htm
      [oracle@rac02 apex_listener]$ java -jar apex.war 
      This Listener instance has not yet been configured.
      Please complete the following prompts
      
      Enter the location to store configuration data:/u01/app/oracle/apex_listener
      Jan 8, 2013 2:29:00 PM oracle.dbtools.common.config.cmds.ConfigDir execute
      INFO: Set config.dir to /u01/app/oracle/apex_listener in: /home/oracle/apex_listener/apex.war
      Jan 8, 2013 2:29:03 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /u01/app/oracle/apex_listener/apex
      Enter the name of the database server [localhost]:rac-scan.akragmbh.local
      Enter the database listen port [1521]:
      Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
      Enter the database service name:rac.akragmbh.local
      Enter the database user name [APEX_PUBLIC_USER]:
      [...]
      Everything worked fine and the configuration is written in defaults.xml. No entry for key "db.sid"
      [oracle@rac02 apex]$ cat /u01/app/oracle/apex_listener/apex/defaults.xml 
      <?xml version="1.0" encoding="UTF-8" standalone="no"?>
      <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
      <properties>
      <comment>Saved on Tue Jan 08 14:30:03 CET 2013</comment>
      [...]
      <entry key="db.hostname">rac-scan.akragmbh.local</entry>
      <entry key="db.password">I don't tell</entry>
      <entry key="db.port">1521</entry>
      <entry key="db.servicename">rac.akragmbh.local</entry>
      [...]
      The Listener and APEX is up und running.

      But when I import the configuration from ApexListener into SQLDeveloper 3.2.20.09 the dialogbox says, I've configured a SID instead of a service name.
      This is the saved configuration
      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
      <properties>
      
      <comment>
         Listener Administration
         Oracle SQL Developer 3.2.20.09.87
         Last Update: Tue Jan 08 16:07:23 CET 2013
      </comment>
      
      <entry key="db.password">I don't tell</entry>
      <entry key="db.connectionType">basic</entry>
      <entry key="db.hostname">rac-scan.akragmbh.local</entry>
      <entry key="db.port">1521</entry>
      <entry key="db.sid">orcl</entry>
      <entry key="db.servicename">rac.akragmbh.local</entry>
      <entry key="db.tnsAliasName"/>
      <entry key="db.tnsDirectory"/>
      <entry key="db.customURL"/>
      [...]
      What is wrong?