Oracle Database Service Start/Stop

-
STOP Database Service
Navigate to database home path
e.g.
cd /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin
./sqlplus "sys/Password as SYSDBA"

SQL> shutdown immediate;

STOP Database(DB) listener service
./lsnrctl stop

./lsnrctl status

ps -ef | grep java
Check there should not be any JAVA processes are running…



START Database Service
Once unix machine is started back in running mode…

START (In below sequence only)
cd /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin

Check listener services are running or not!
./lsnrctl start

./lsnrctl status

Login to DB as sysdba
./sqlplus "sys/Password as SYSDBA"


SQL> startup;
ORACLE instance started.

Total System Global Area     6241124352 bytes
Fixed Size                              8634512 bytes
Variable Size                         1258295152 bytes
Database Buffers                   4966055936 bytes
Redo Buffers                         8138752 bytes
Database mounted.
Database opened.

SQL> alter session set container=ORCLPDB1;

SQL> show con_name;

SQL> startup;
Pluggable Database opened.

##Below steps only for Oracle 19c
SQL> alter session set container=ORCLPDB1; 
SQL> show con_name; 
SQL> startup; 
Pluggable Database opened. 

SQL> SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE; 

SQL> exit;

./lsnrctl status

./lsnrctl reload


[server bin]$ tnsping my.host.com

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production

Copyright (c) 1997, 2016, Oracle.  All rights reserved.

Used parameter files:
/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=my.host.com)(PORT=1521)))
OK (0 msec)

Comments

Post a Comment

Popular posts from this blog

PUTTY - The server's host key is not cached in the registry cache

-
Error: "The server's host key is not cached in the registry. You have no guarantee that the server is the computer you think it is. The server's rsa2 key fingerprint is: [SSH KEY FINGERPRINT] If you trust this host, enter "y" to add the key to PuTTY's cache and carry on connecting. If you want to carry on connecting just once, without adding the key to the cache, enter "n". If you do not trust this host, press Return to abandon the connection. Store key in cache? (y/n) y" Answer: Simply run this command in your windows preferred terminal (cmd.exe etc) and agree to accept the host and store the cache: C:\Program Files (x86)\PuTTY\plink.exe -ssh [SSH USERNAME]@[SSH HOST] -P [SSH PORT] echo y | pscp -i /path/to/key/file user@remote:/tmp/file  . echo y | plink -i /path/to/key/file scripts.sh Usually you would hit “y” here, assuming the host key is correct, in order to store it in future connection.  The storage of this goes into the Registry under ...
Read more

OIM-12c Installation - FMW - SOA - IDM

-
Image
Oracle Identity Manager (OIM) 12c Installation Prerequisites: The Oracle Identity Manager software includes the following: 1] Oracle's Java Development Kit (JDK) 1.8 (jdk-8u311-linux-x64.tar.gz) 2]  Fusion Middleware 12.2.1.4.0 3]  SOA Suite 12.2.1.4.0 4] Oracle Identity and Access Management  12.2.1.4.0 What Do You Need? For completing Oracle IDM Setup you will need, Environment as below: Oracle Enterprise Linux 6 or similar, with access to the Internet At least 8GB RAM (16GB recommended) An Oracle Database Enterprise Edition 12 or superior installed and running. Note: Installing a Database for Identity and Access Management (IDM) Suite provides instructions on how to install an Oracle Database that is suitable for Oracle Identity and Access Management Suite. oracle and root user credentials SYS database user credentials Basic understanding of Linux An Oracle Technology Network (OTN) account OIM-11g PS3 Installation Steps: Just for reference https://www.oracle.com/webfol...
Read more

SAML & OAuth 2.0

-
Both SAML (Security Assertion Markup Language) and OAuth 2.0 are widely used protocols for authentication and authorization in web applications, but they serve different purposes. SAML (Security Assertion Markup Language) Purpose: Primarily designed for authentication and single sign-on (SSO) . How it works: A user attempts to access a service provider (SP). The SP redirects the user to an identity provider (IdP). The IdP authenticates the user and sends a SAML assertion to the SP. The SP validates the assertion and grants access to the user. Common use cases: Enterprise applications, government services, and federated identity management systems. OAuth 2.0 Purpose: Designed for authorization , allowing users to grant third-party applications access to their data on a specific service. How it works: A user attempts to access a resource on a service provider. The SP redirects the user to the authorization server. The user grants permission to the application. The authorization s...
Read more