How start and Stop Oracle Database on a Linux host

Today we are going to see and learn about starting and shutting down an Oracle Database. Pre-requisites:- There are few pre-requisites before we attempt to start or stop a database. The database should exist on the Linux host. ORACLE_SID, ORACLE_HOME, CLASS_PATH and PATH environment variables must be set. How to validate pre-requisites? run command "cat… Continue reading How start and Stop Oracle Database on a Linux host

Configure Oracle Database Static Listener

Follow below steps to configure static Oracle Database listener. Currently, I do not have any listener configured on my setup and "lsnrctl status" is not showing any result. [grid@ib-auto-sco-asm154 ~]$ lsnrctl status LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 29-AUG-2018 20:03:33 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ib-auto-sco-asm154)(PORT=1521))) STATUS of… Continue reading Configure Oracle Database Static Listener