November | 2015 | DBA Knowledge Base

In SQL*Plus, how do I change the prompt to show the connected user and database?

November 18, 2015 Leave a comment

#Connect as oracle user and add the following line at the end of th glogin.sql script.

su - oracle
vi $ORACLE_HOME\sqlplus\admin\glogin.sql
set sqlprompt "_user '@' _connect_identifier > "

#Now check

sqlplus / as sysdba
SYS @ LBTCI1 >

November 17, 2015 Leave a comment

$ crontab -e
You (oracle) are not allowed to use this program (crontab)
See crontab(1) for more information

# The following files control crontab usage

/etc/cron.allow
/etc/cron.deny

# Go to the root user and add oracle user to the following file:

echo oracle > /etc/cron.allow

# Or delete oracle from /etc/cron.deny file. 🙂