Month: July 2021

How to run Autoconfig in Database Tier and Application Tier in Oracle EBS R12.2 ?

Leave a Comment / Autoconfiq run Database / By

   1. Database autoconfig:   1.  To source the environment file from the $ORACLE_HOME   oracle@visebsdb 12.1.0]$ . VIS_visebsdb.env    2. To connect the SQLPLUS   [oracle@visebsdb 12.1.0]$ sqlplus / as sysdba   SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 16 23:08:28 2021   Copyright (c) 1982, 2014, Oracle.  All rights reserved.   Connected to …

How to run Autoconfig in Database Tier and Application Tier in Oracle EBS R12.2 ? Read More »

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

Leave a Comment / Startup Database and Application in r12.2 / By

   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 (c) 1982, 2014, Oracle.  All rights reserved. …

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

Starting and Stopping OBIEE 12c Services in Linux

Leave a Comment / OBIEE 12c status, stop and starting OBIEE 12c / By

      Go to following Directory: /devapps/OBIEE/Middleware/user_projects/domains/bi/bitools/bin   To Know the Status of All Services : [obiee@obiee-app bin]$ ./status.sh Domain status; Using domainHome: /devapps/OBIEE/Middleware/user_projects/domains/bi …   Initializing WebLogic Scripting Tool (WLST) …   Welcome to WebLogic Server Administration Scripting Shell   Type help() for help on available commands   <Jul 3, 2021 9:05:07 AM …

Starting and Stopping OBIEE 12c Services in Linux Read More »

How to Create Custom Schema in Oracle 11g /12c ?

Leave a Comment / Create Schema in Oracle 11g and 12c / By

Create  the following  details to create :   username : archive_purge password: archive123 tablespace name : archive_purge temporary tablespace name: temp To Create  tablespace : SQL>CREATE TABLESPACE archive_purge DATAFILE ‘/u01/MIC1213/db/apps_st/data/archive_purge01.dbf’ size 5G; To Create Create User : SQL> create user archive_purge identified by archive123 temporary tablespace temp default tablespace archive_purge; To Permission to User : SQL> grant connect …

How to Create Custom Schema in Oracle 11g /12c ? Read More »