How to Start Database and Application in ORACLE EBS R12.2

To Start the Database(12c) :

In the ORACLE_HOME source the environment file (ie VIS_ebs-db.env)

[oracle@ebs-db 12.1.0]$ . VIS_ebs-db.env

To connect the SQLPLUS :

[oracle@ebs-db 12.1.0]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 1 11:25:09 2021

Copyright © 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

To startup the Database :

SQL> startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 2147483648 bytes

Fixed Size 2926472 bytes

Variable Size 520095864 bytes

Database Buffers 1610612736 bytes

Redo Buffers 13848576 bytes

Database mounted.

Database opened.

To check the status of the Database:

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

— — — — — — — — — — — — — — —

VIS READ WRITE

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release…