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
I've configured the ApexListener via command line interface as described in
[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 "">
<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 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 "">

   Listener Administration
   Oracle SQL Developer
   Last Update: Tue Jan 08 16:07:23 CET 2013

<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?


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