Database Administration (MOSC)

MOSC Banner

SP2-0306 Invalid Option / ORA-12457 TNS:lost connection error

I have a script to check tablespace size for 12c which is running fine.

However, when I run the same script on my 19c server it is giving SP-0306 and ORA-12457 related message. Here is the script....

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

#!/bin/bash

export MMSG=/tmp/$$.mail

export ADDR="abc@xyz.co.jp"

export NLS_LANG=Japanese_Japan.UTF8

export ORACLE_HOME=/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/

export LD_LIBRARY_PATH=/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1/lib

export ORACLE_SID=K3DB

file=/tmp/${$}_`date +%Y%m%d`


$ORACLE_HOME/bin/sqlplus -s "/ as sysdba" << .eof > $file

set pages 0


ALTER SESSION SET CONTAINER = K3DB01;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center