Setup glogin.sql

  

Setup glogin.sql in Oracle

Setup glogin.sql in Oracle

Let's take you want to execute some sql commands every time you login to SQL*PLUS. It would be so hard to run those commands manually whenever you start SQL*PLUS. With glogin.sql you can specify the commands you want to run every time you invoke SQL*PLUS.

Any query, script, parameter, PL/SQL code etc, you can simply put under glogin.sql file and SQL*PLUS will first execute glogin.sql before allowing you to query database.

I would like to display below message every time a user logs into the database

SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 19 14:47:05 2023

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Hello

------------------------------------------------

Welcome, you are connected to MOMDEV database

setup glogin.sql in oracle - testdb database 

Open the glogin.sql file

vi $ORACLE_HOME/sqlplus/admin/glogin.sql

Put below query at the end of the file

select 'Welcome, you are connected to '||name||' database' "Hello" from v$database;

Save and close. That's it, now whenever you login to SQL*PLUS, you will be greeted with a nice welcome message!

start weblogic managed server

 vi start-domain.sh

# -----------------------------------------------------------------------------------

# File Name    : start-domain.sh

# Author       : AMIR DBA

# Description  : Starts a WebLogic domain and managed server.

# Call Syntax  : ./start-domain.sh

# Notes        : Amend DOMAIN_HOME and managed server name appropriately.

# -----------------------------------------------------------------------------------

export MW_HOME=/u01/app/oracle/middleware

export DOMAIN_HOME=$MW_HOME/user_projects/domains/clusterDomain

echo "Starting AdminServer"

nohup $DOMAIN_HOME/startWebLogic.sh > /dev/null 2>&1 &

sleep 120

echo "Starting clusterServer_1"

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh clusterServer_1 > /dev/null 2>&1 &

sleep 60

echo "Done!"