Enable Non-Oracle User Run SQL*Plus
Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »Enable Non-Oracle User Run SQL*Plus
CONNECT
sqlplus Connecting Hang?
SQL*Plus Network Issues At times, we see that some logins and connections are not responding and indefinitely hang in tools like SQL*Plus. In most cases,… Read More »sqlplus Connecting Hang?
SQLPlus Connect and Disconnect
SQLPlus Connect To connect a database, we usually use sqlplus, a text-based connection tool provided by Oracle to facilitate clients to connect to a running… Read More »SQLPlus Connect and Disconnect
How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied
ORA-01045 ORA-01045 means that the user who tried to connect to the database has no privilege to connect to. Therefore, the database refused the user… Read More »How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied