This is an easy one, but really helpful when you are on a server with a few DB’s and you want the visual piece of mind you are not doing something on the wrong database.
Add the following line on file $ORACLE_HOME/sqlplus/admin/glogin.sql
SET SQLPROMPT "_USER'/'_CONNECT_IDENTIFIER> "That’s it, now try to access DB:
[oracle@server ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu May 29 12:11:20 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.25.0.0.0
SYS/DBNAME>
Comments