Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

SQLPLUS "forgets" ORACLE_SID

Hello,

I currently try to install ORACLE database 12.2.0.1 on a Win2016 server by using the scripts I've used many times before with other versions of Windows...

This script defines the environment-variable SET ORACLE_SID=MOBILE after having installed the service with ORADIM -NEW -SID MOBILE -INTPWD aaaaBBBBBB2020! -STARTMODE MANUAL -PFILE "D:\INITdatabase\MOBILE\ORA\pfile\init.ora"

The install itself is done by SQLPLUS/NOLOG @D:\INITdatabase\MOBILE\ORA\install\Install_1_INSTANCE.ora

SQL> spool D:\INITdatabase\MOBILE\ORA\install\log\Install_1_INSTANCE.log

SQL> connect SYS/aaaaBBBBBB2020! as sysdba;

ERROR:

ORA-12560: TNS: Fehler bei Protokolladapter

All this is done in a script/batch. When opening a command-shell and typing (cut&paste) all commands (set... and sqplus...) by hand, it works.

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