# [26ai] ConnStr Tool *If you prefer to read in Spanish* [***Spanish version***](https://dbaenlasombra.com/26ai-connstr-tool)*.* Today, let's talk about the new feature in 26ai: the **ConnStr** tool. The tool is a command-line utility that it works in order to display the connections for every service in **Easy Connect**, **JDBC** and **Python** formats, with the option to include this information in **tnsnames**. Another point, when we use the new tool, the listener should be up, otherwise, it will fail. So, let's get down to business! Let's check the **listener**: ```sql [oracle@~]$ lsnrctl status LSNRCTL for Linux: Version 23.26.0.0.0 - for Oracle Cloud and Engineered Systems on 25-MAR-2026 14:28:21 Alias LISTENER Version TNSLSNR for Linux: Version 23.26.1.0.0 - Production Start Date 09-MAR-2026 17:13:58 Uptime 15 days 21 hr. 14 min. 23 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/23.0.0.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/l23ai/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=X.X.X.X)(PORT=1521))) Services Summary... Service "+APX" has 1 instance(s). Instance "+APX1", status READY, has 1 handler(s) for this service... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_RECO" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 1 handler(s) for this service... Service "XXXXX.paas.oracle.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.paas.oracle.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.paas.oracle.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... Service "XXXXX.XXXXX.XXXXX.oraclevcn.com" has 1 instance(s). Instance "DB23ai", status READY, has 2 handler(s) for this service... The command completed successfully ``` All right, the **listener** is up. Let's execute the new command **ConnStr** in order to see what information we can get: ```sql [oracle@ ~]$ connstr Using Listener: LISTENER with Oracle Home: /u01/app/oracle/product/23.0.0.0/dbhome_1 Service Name: XXXXXXXXX.paas.oracle.com Connection String: X.X.X.X:1521/XXXXXXXXX.paas.oracle.com Service Name: XXXXXXX.XXXXXX.vcn23ai.oraclevcn.com Connection String: X.X.X.X:1521/XXXXXX.XXXXXXXX.vcn23ai.oraclevcn.com ... ... Connection strings can be used to connect to the specified service name. For SQL*Plus you can use: SQL> connect username@X.X.X.X:1521/XXXXX.paas.oracle.com For Python you can use: connection = oracledb.connect(user="username", password="password", dsn="X.X.X.X:1521/XXXXXX.paas.oracle.com") For JDBC Thin you can use: OracleDataSource ods = new OracleDataSource(); ods.setURL("jdbc:oracle:thin:@X.X.X.X:1521/XXXXXX.paas.oracle.com"); ods.setUser("username"); ods.setPassword("password"); Connection conn = ods.getConnection(); Write connect strings to tnsnames.ora (Y/N)? (Default: N): ``` Awesome! **connstr** displays the connection strings for **Easy Connect**, **JDBC,** and **Python.** In the last line, **connstr** give us the possibility to include the connection string in the **tnsnames.ora**! In this case, we used the command directly because we have an single **listenner**. In case we have several listeners, we can use the following parameter in order to filter by listener "**connstr -L** ". Other useful utitlities are as follows: * List the available **listeners**: ```sql [oracle@~]$ connstr -e PROTOCOL PORT HOST tcp 1521 X.X.X.X ``` * List the available services: ```sql [oracle@~]$ connstr -s XXXXXXXX.paas.oracle.com XXXXXXXX.paas.oracle.com XXXXXXXX.XXXXXXXX.vcn23ai.oraclevcn.com pdb_david.XXXXXXXX.vcn23ai.oraclevcn.com +APX +ASM +ASM_DATA +ASM_RECO XXXXXXXX.XXXXXXXX.vcn23ai.oraclevcn.com XXXXXXXX.paas.oracle.com XXXXXXXX.XXXXXXXX.vcn23ai.oraclevcn.com XXXXXXXX.XXXXXXXX.vcn23ai.oraclevcn.com ``` * Getting the connection string in **JDBC** format filtered by service. ```sql [oracle@ ~]$ connstr -j pdb_david jdbc:oracle:thin:@X.X.X.X:1521/XXXXXXXX.paas.oracle.com ``` * Getting the connection string filtered by service. ```sql [oracle@~]$ connstr -d pdb_david (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=X.X.X.X)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XXXXXXXX.paas.oracle.com))) ``` * Getting the connection string in **Easy Connect** format filtered by service. ```sql [oracle@~]$ connstr -z pdb_david X.X.X.X:1521/XXXXXXXX.paas.oracle.com ``` Looking forward to seeing you in the next article :)