This discussion is archived
2 Replies Latest reply: Jan 9, 2013 2:05 AM by 838196 RSS

ApexListener 2.0 configured with service name but SQLDeveloper says SID

838196 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points