Sports

https://www.espncricinfo.com/ci/engine/match/scores/desktop.html
Showing posts sorted by date for query Oracle. Sort by relevance Show all posts
Showing posts sorted by date for query Oracle. Sort by relevance Show all posts
Monday, September 19, 2022

How to Install HRMS Legislative Data

How to apply Oracle Hrglobal Legislative Patch

oracle hrms login
  

HRMS Global Steps

  •   Stop Apps Services  

  • Set Apps environment and enable Maintenance Mode.

                . ./apps/apps_st/appl/TEST_paytest.en

  • Enable Maintenance Mode using adadmin command

              Choose 5 and 1 Options Enable Maintenance Mode and finally press Enter Key twice       






  • Download Unzip and Apply Patch p11072961_R12.FND.B_R12_LINUX.zip
  • Download Unzip and Apply Patch p16000686_R12.HR_PF.B_R12_LINUX.zip 
  • Run Data Install

        “java oracle.apps.per.DataInstall apps apps thin hrtest.mydomain.com:1521:TEST

  • Select Options 1I (I stands for Install)

        Select 1st Option for Global HRMS and Type 1I 
          Press 4 Exit with Y option which saves your settings

  • Now Apply "hrglobal.drv" Patch
        $PER_TOP/12.0.0/patch/115/driver/hrglobal.drv 

  • Disable Maintenance mode

  • Start Apps Services
  

  •     Conclusion
            I hope that in this way, we can apply hrglobal.drv with this article.





Labels:
Thursday, September 15, 2022

Scheduling Oracle Enterprise 13c OMS backup

13c OMS Schedule Backup

Overview

Let's configure Oracle 13c OMS that is running with the following details:-

Operating System        Oracle Linux 6.10 (el6uek.x86_64)

Database SID               testdb

Database Version         Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Oracle 13c OMS Ver   Oracle Enterprise Manager Cloud Control 13c Release 3

Following is the script for taking weekly cold backup for 13c OMS Server in a Linux environment

Step 1

Create a script with cold.sh as per my sample script

Script

echo

echo

date

echo

echo "Shutting Down OMS Services of 13c Monitoring Cloud Control for Cold Backup ......."

echo

echo

echo

export ORACLE_HOME=/u01/db/dbhome_1

export ORACLE_SID=testdb

export OMS_HOME=/u01/cloud/middleware

export AGENT_HOME=/u01/cloud/agent/agent_13.3.0.0.0

$OMS_HOME/bin/emctl stop oms -all

/u01/cloud/agent/agent_13.3.0.0.0/bin/emctl stop agent

echo "Shutting Down Database and Listener Services of 13c Monitoring Cloud Control for Cold Backup ......."

echo

echo

echo

#$ORACLE_HOME/bin/sqlplus "/ as sysdba" <<EOF1

#shutdown immediate;

#EOF1

#sqlplus "/ as sysdba" <<EOF1

#shutdown immediate;

#EOF1

#$ORACLE_HOME/bin/lsnrctl stop

date

echo

sleep 10;

date

echo "All Services are down for 13c Monitoring Cloud Control Cold Backup ......."

echo

echo

echo

date

echo "Starting Tar Backup for 13c Monitoring Cloud Control with Database"

echo

echo

echo

AS1=Oracle13c-OMS-TAR_$(date +%d-%m-%Y).tgz

#AS2=Oracle13c-DB-TAR_$(date +%d-%m-%Y).tgz

#AS3=Oracle13c-DBInventory-TAR_$(date +%d-%m-%Y).tgz

echo

/bin/tar -cvzf /u01/backup/cold/$AS1 /u01/cloud

#/bin/tar -cvzf /u01/backup/cold/$AS2 /u01/db

#/bin/tar -cvzf /u01/backup/cold/$AS3 /u01/oraInventory

echo

echo

date

echo

echo "Backup Successfully Completed for 13c Monitoring Cloud Control"

echo "Starting 13c Monitoring Cloud Control Services ......."

$ORACLE_HOME/bin/lsnrctl start

$ORACLE_HOME/bin/sqlplus "/ as sysdba" <<EOF1

startup;

EOF1

$OMS_HOME/bin/emctl start oms

/u01/cloud/agent/agent_13.3.0.0.0/bin/emctl start agent

date

echo "All Services are Up after 13c Monitoring Cloud Control Cold Backup Completion ......."

echo

echo


Step2

Create a crontab schedule job for running the above script on a weekly basis

01 00 * * 6 /home/oracle/backup/scripts/cold.sh > /home/oracle/backup/logs/cold.log

Conclusion

This script will run at 00:01 on Saturday Night, you may change it accordingly as per your desired time.


Labels: , ,
Thursday, September 15, 2022

Migrate Weblogic Domain to another Server

Migrate WebLogic 12c steps in Linux

Overview

Here I am going to share with you how we can rename WebLogic 11g Instance for cloning purposes or as per any other requirement.

Example

We have 2 x Linux Servers

Server 1 = prodserver.domain.com

Server 2 = testserver.domain.com

Step 1

Edit file vi /oracle/domains/FRDomain/config/fmwconfig/servers/AdminServer/applications/em/META-INF/emoms.properties

And change

1.       oracle.sysman.emSDK.svlt.ConsoleServerHost=testserver.domain.com

2.       oracle.sysman.emSDK.svlt.ConsoleServerName=testserver.domain.com:7001_Management_Service

Step 2

Open file /oracle/domains/FRDomain/servers/WLS_REPORTS/tmp/_WL_user/reports_11.1.2/uxabaw/configuration/rwservlet.properties and change host name entry.

Step 3

Edit Start and Stop Web logic scripts

Open file /oracle/domains/FRDomain/bin/startWebLogic.sh and edit host name entry.

Open file /oracle/domains/FRDomain/bin/stopWebLogic.sh and edit host name entry.

Open file /oracle/domains/FRDomain/bin/startManagedWebLogic.sh and edit host name entry.

Open file /oracle/domains/FRDomain/bin/stopManagedWebLogic.sh and change host name entry.

Step 4

Verify both scripts

1)      Start Weblogic using script and Form and Report Services.

2)      Stop Weblogic using script and Form and Report Services.

Conclusion

In this way, we can make a Test Server for Weblogic Forms and Reports environment.

Labels:
Wednesday, April 26, 2017

How to Apply Opatch in Oracle Apps R12

How to apply Opatch in Oracle Home in ERP R12



OPATCH CONFIGURATION ISSUES
A.      ERROR: OPatch failed because of an Inventory problem.
B.      ERROR: OPatch failed because of problems in the patch area.
C.      The patch directory area must be a number.

SOLUTION
1.       First of Check and locate /etc/oraInst.loc, File, and see Inventory path. It must be According to Current Environment SID.
2.       For applying OPatch in EBS, one should remember to copy New Patch in /d01/oracle/PROD/apps/tech_st/10.1.2/.patch_storage Directory.

HOW TO APPLY PATCH
·         Set Apps Node environment variable.
·         Copy Zip file to /d01/oracle/PROD/apps/tech_st/10.1.2/.patch_storage location.
·         Unzip File and go to the newly created Patch directory.
·         run command "opatch apply" and wait for the completion process


Enjoy Opatch patching ..............................
Labels: , , ,
Wednesday, October 21, 2015

Oracle BI Publisher 12c Installation Step by Step

obiee 12c installation on linux step by step

How to Install BI Publisher on Linux 

1) Download BI Publisher from Oracle Support


Download BI Publisher from Oracle Support in Developer tools

download BI_Publisher_Trial_linux_32-64bit_generic.zip file

2) Create a Directory for BI Home and Unzip


mkdir -p /oracle/BI

copy here BI_Publisher_Trial_linux_32-64bit_generic.zip file using Winscp and unzip the file

3) Set JAVA_HOME Path in .bash_profile


JAVA_HOME=/usr/lib/jvm/java-1.6.0 export JAVA_HOME

PATH=/usr/sbin:${JAVA_HOME}/bin:$JAVA_HOME/db/bin:$PATH; export PATH

4) Run configureBI.sh to Install it


Goto /oracle/BI/BI_Publisher_Trial directory and run the following script:

> sh configureBIP.sh

> Provide admin user

> Provide Password for Admin User

5) How to Access BI Publisher

open Url on the web as "http://hostname:7001/xmlpserver/

> Give username and Password and enjoy Bi Publisher

6) How to Start BI Publisher


Goto /oracle/BI/BI_Publisher_Trial/bin directory and run the following script:

>sh startBIP.sh

7) How to Stop BI Publisher


Goto /oracle/BI/BI_Publisher_Trial/bin directory and run the following script:

>sh stopBIP.sh
Labels: ,
Wednesday, October 15, 2014

Migrate Oracle Database Windows to Linux

oracle database migration from windows to linux using


Convert Oracle Database Windows to Linux


Open oracle database  SQL prompt from the command line for checking the current OS Version

Finding Supported platforms (Need to connect to SQLPLUS)


sqlplus “/ as sysdba”


SQL> select * from v$transportable_platform order by 2;

Checking the Number of Objects in our database

Query is
Select count(*) from dba_objects;


As we can see our source database has 79885 objects
Note: We will compare it After the Migration process completion

Verifying the SOURCE database is ready for migration

Database Name: testdb
Platform Name: Microsoft Windows IA (32-bit)


Note: We will shutdown the database first and open it in read-only mode

Shutdown immediate;
Startup mount;
Alter database open read only;



Now below command will make it ready for migration

Set serveroutput on;
Declare
V_return Boolean;
Begin
V_return:=dbms_tdb.check_db('Linux x86 64-bit');
End;
/
PL/SQL procedure successfully completed. (See below Window);


Check and See if External objects are present 
Declare
V_return Boolean;
Begin
V_return:=dbms_tdb.check_external;
End;
/
PL/SQL procedure successfully completed. 

The following directories exist in the database we will use for this activity: 
SYS.DATA_PUMP_DIR 

We are not using it here in this exercise (We will Skip this Step)

Open RMAN prompt for Starting Conversion

Commands to Run (Windows CMD)

rman target /

Converting Database or Preparing for our Destination OS

Command
convert database new database 'testdb' transport script 'C:\Users\kamran\testdb\trasnport.sql' db_file_name_convert 'D:\app\oradata\testdb\testdb' 'C:\Users\kamran\testdb';


Now over transport.sql script is ready, so we will move forward to the Target instance and complete the migration process

Now create Pfile from SPfile on Source database Windows Server using below

Command

 create pfile='C:\Users\kamran\testdb\init_testdb.ora' from spfile;


Copy Source datafile from c:\users\kamran\testdb to Destination Linux using Winscp



Destination Server Settings (Linux Server 64 Bit)

Name     pmstestug
Version   el6uek.x86_64  

Create following directories 

mkdir -p /d02/app/oracle/flash_recovery_area/testdb
mkdir -p /d02/app/oracle/oradata/testdb
mkdir -p /d02/admin/TESTDB/pfile
mkdir -p /d02/admin/TESTDB/adump
mkdir -p /d02/admin/TESTDB/dbdump

Edit init_testdb.ora

Change destination path as per the below image



Executing TRANSPORT.SQL Script on destination




Conclusion

We have successfully migrated our Windows 32 Bit Oracle 11g Database to Linux 64Bit


Thanks for your time and patience.




Labels: , ,
Wednesday, October 15, 2014

Enable archivelog Mode Oracle 11g

change archive log destination

11g Database in ARCHIVELOG Mode


In this exercise, you will configure the database for ARCHIVELOG mode. You will then actually put the database in ARCHIVELOG mode.

1.            Create a directory called c:\oracle\arch\arch.

2.      Log into your database using SQL*Plus. Check the log mode the database is in by querying the LOG_MODE column in V$DATABASE.
C:\oracle\orabackup\orcl>          SQLPLUS SYS AS SYSDBA
SQL>      SELECT LOG_MODE FROM V$DATABASE;

LOG_MODE
-------------------------
NOARCHIVELOG

3.        Using the alter system command, set the LOG_ARCHIVE_DEST_1 parameter to point to the new directory you created in step 1.
SQL>      ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’LOCATION=C:\ORACLE\ARCH\ORCL’;
System altered.


4.         Shut down the database using the shutdown immediate command.

SQL>   SHUTDOWN IMMEDIATE


5.     Put the database in MOUNT mode with the startup mount command. Confirm that the database is in MOUNT mode by querying the OPEN_MODE column in V$DATABASE.
SQL>      STARTUP MOUNT
SQL>      SELECT OPEN_MODE FROM V$DATABASE;

OPEN_MODE
----------------
MOUNTED


6.     Now put the database in ARCHIVELOG mode using the alter database archivelog command.
SQL>      ALTER DATABASE ARCHIVELOG;
Database altered.


7.            Open the database with the alter database open command. Check the LOG_MODE parameter
of the V$DATABASE view to ensuring that the database is in ARCHIVELOG mode.
SQL>      ALTER DATABASE OPEN;
Database altered.
SQL>      SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
------------
ARCHIVELOG


8.            To ensure that the database is configured correctly, force a log switch.
SQL>      ALTER SYSTEM SWITCH LOGFILE;
System altered.



9. Now check the directory c:\oracle\arch\orcl to ensure that the archived redo logs are being created correctly.

SQL>      Host dir c:\oracle\arch\orcl
Labels: ,
Wednesday, October 15, 2014

How to Take Oracle Database Backup Step by Step

Oracle Hot Backup Restore steps

Oracle 11g Manual Online Hot Backup

In this lab, you will perform an online/hot backup of your database, with the database still running.

1.         Create a directory for the backups. In this lab, we use c:\oracle\orabackup\orcl\hot.
We assume that the directory structure c:\oracle\orabackup\orcl is already created from the work you did in Lab 2.1.
C:\>cd oracle\orabackup\orcl
C:\oracle\orabackup\orcl> Mkdir Hot
2.         Log into your database using SQL*Plus. Check the log mode the database is in by
querying the LOG_MODE column in V$DATABASE. It should be in ARCHIVELOG mode.
C:\oracle\orabackup\orcl>          SQLPLUS SYS AS SYSDBA
SQL>    SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
-----------------
ARCHIVELOG
3.         Using the DBA_DATA_FILES view, determine the data files that you will need to back up.
SQL>    SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_DATA_FILES;
TABLESPACE_NAME   FILE_NAME
---------------                     ----------------------------------------
USERS                         C:\ORACLE\ORADATA\ORCL\USERS01.DBF
UNDOTBS1                   C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
SYSAUX / SYSTEM      C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF .. SYSTEM01.DBF
4.         Using the V$LOG view; determine which sequence is the current online redo log sequence.
You must ensure that you have this log sequence and all logs generated during the backup
in order to be able to restore the backup.
SQL>    SELECT GROUP#, SEQUENCE#, STATUS FROM V$LOG;
GROUP#           SEQUENCE#    STATUS
---------- ---------- ----------------
1                      4                      CURRENT
2                      2                      INACTIVE
3                      3                      INACTIVE
5.         Put the database in hot backup mode with the alter database begin backup command.
SQL>    ALTER DATABASE BEGIN BACKUP;                 Database altered.
6.         Copy all database data files (all have an extension of .dbf) to the backup directory created in step 1.
SQL>    host C:\oracle\orabackup\orcl>>Copy c:\oracle\oradata\orcl\*.dbf           5 file(s) copied
7.         Using the V$LOG view, determine which sequence is the current online redo log sequence. You must ensure that you have this log sequence and all logs generated during the backup to restore the backup. Here, we need log sequences starting with 4 (when we started our backup) and continuing through log Seq7.
SQL>    SELECT GROUP#, SEQUENCE#, STATUS FROM V$LOG;
GROUP#           SEQUENCE#                STATUS
-------------           -------------------                 --------------
1                                  7                      CURRENT
2                                  5                      INACTIVE
3                                  6                      INACTIVE
8.         Take the database out of hot backup mode with                         ALTER DATABASE END BACKUP;
9.         Use the command to force a switch from log sequence 7.  ALTER SYSTEM SWITCH LOGFILE;
10.          Check the archive-log directory to make sure log-file sequences 4 through 7 have been created.
SQL>    SHOW PARAMETER LOG_ARCHIVE_FORMAT
NAME                                       TYPE                           VALUE
-----------------                               ---------                           -----------
log_archive_format                    string                            ARC%S_%R.%T
SQL>      SHOW PARAMETER LOG_ARCHIVE_DEST_1

11.        Copy the archived redo logs to the backup location.
SQL>      Host copy c:\oracle\arch\orcl\arc*.* c:\oracle\orabackup\orcl\hot\*.*

12.        Check the backup directory to ensure that all the files needed are in place.
SQL>    Host dir c:\oracle\orabackup\orcl\hot\*.*

13.        This is an optional step. Now that we know our archived redo logs were copied successfully, we can remove them from the archive-log directory if we want.
Labels: , ,

Popular