# [26ai] ConnStr Tool *El artículo también se encuentra publicado en Ingles* [***English version***](https://dbaintheshadow.com/26ai-connstr-tool)*.* En el artículo de hoy, vamos a ver la nueva herramienta que se ha introducido en la 26ai **ConnStr** . Es una herramienta command-line que sirve para mostrar las conexiones por cada servicio definido en nuestra base de datos en formatos **Easy Connect**, **JDBC** y **Python**, dándonos la posibilidad de incluir esa información dentro del **tnsnames**. Otro punto que hay que tener en cuenta es que el listener debe estar levantado, sino nos dará error. Sin más, vamos al lío. Revisamos cómo se encuentra el **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 ``` Perfecto, el **listener** esta arriba. Vamos a ejecutar **ConnStr** y veamos que información nos da: ```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): ``` Que maravilla de output no? Oracle nos facilita de manera muy sencilla las cadenas de conexión para **Easy Connect**, **JDBC** y **Python.** Y como nota final, nos da la opción de incluir las cadenas en el **tnsnames.ora**! En este caso, hemos ejecutado directamente el comando porque tenemos un único **listener**. Si tuviéramos más de un listener, podríamos especificar la opción **\-L** junto con el nombre del listener. Otras utilidades del comando son las siguientes: * Listar los **listener** disponibles. ```sql [oracle@~]$ connstr -e PROTOCOL PORT HOST tcp 1521 X.X.X.X ``` * Listar los servicios disponibles: ```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 ``` * Obtener la conexión **JDBC** de un servicio ```sql [oracle@ ~]$ connstr -j pdb_david jdbc:oracle:thin:@X.X.X.X:1521/XXXXXXXX.paas.oracle.com ``` * Obtener la cadena de conexión de un servicio ```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))) ``` * Obtener la cadena de conexión de un servicio en formato **Easy Connect**. ```sql [oracle@~]$ connstr -z pdb_david X.X.X.X:1521/XXXXXXXX.paas.oracle.com ``` Espero que os guste. ¡Nos vemos en el próximo artículo!