Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12514: TNS:listener does not currently know of service requested

DBA2011Jun 13 2007 — edited Jun 25 2007
Sometime listener behaviour is strange, wondering why?

SQL> connect sys/test@testdb as sysdba;
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

SQL> connect sys/test@testdb as sysdba;
Connected.

listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = OracleLab)(PORT = 1521))
)
)

SID_LIST_listener_name=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=TESTDB)
(SID_NAME=TESTDB)
(ORACLE_HOME=D:\oracle\Product\db)))


(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=TESTDB1)
(SID_NAME=TESTDB1)
(ORACLE_HOME=D:\oracle\Product\db)))

(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=DEV)
(SID_NAME=DEV)
(ORACLE_HOME=D:\oracle\Product\db9i)))

Comments

843807 
tree.addTreeSelectionListener(new javax.swing.event.TreeSelectionListener() {
            public void valueChanged(TreeSelectionEvent e) {
                // do whatever you want with table in here            
}
        });
Tonny
http://www.kiyut.com
(swing component)
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 23 2007
Added on Jun 13 2007
#general-database-discussions
19 comments
5,995 views