Environment: Operating System: Windows 11 Pro Oracle Database: 23ai 1) Connecting Locally using OS Authentication: When you install Oracle Database Free, your Windows user is automatically added to the ORA_DBA operating system group, which grants you the SYSDBA privileges. Use the following commands to connect to the database. These commands connect you to the root container CDB$ROOT of the multitenant database (CDB) as database user SYS.C:\Windows\System32>set ORACLE_SID=FREE C:\Windows\System32>sqlplus / as sysdba  2) Connecting to Oracle Database Using Easy Connect Naming Method: You can connect to the database using the following Easy Connect strings: - Multitenant container database: host[:port] - Pluggable database: host[:port]/service_name Connection strings for local connections were provided on the final screen of the installation.  - Multitenant container database: host[:port] C:\Windows\System32>sqlplus sys/sys123@dbserver_hostname:1521 as sysdba  - Pluggable database: host[:port]/service_name C:\Windows\System32>sqlplus sys/sys123@dbserver_hostname:1521/FREEPDB1 as sysdba  |
Thanks for reading this post ! Please comment if you like this post ! Click FOLLOW to get future blog updates !
Thank you for your comment !