create local yum repositry

  [root@erp-ides Packages]# pwd

/media/cdrom/Packages

[root@erp-ides repo]# rpm -Uvh deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm

Preparing...                ########################################### [100%]

   1:deltarpm               ########################################### [100%]

[

[root@erp-ides repo]# rpm -Uvh python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm

Preparing...                ########################################### [100%]

   1:python-deltarpm        ########################################### [100%]

[root@erp-ides repo]# rpm -Uvh createrepo-0.9.9-22.el6.noarch.rpm

Preparing...                ########################################### [100%]

   1:createrepo             ########################################### [100%]

   

mkdir -p /oracle/repo/repodata

cp *    /oracle/repo/

cp /media/cdrom/repodata/*comps*.xml  /oracle/repo/repodata

cd /oracle/repo/

[root@erp-ides repo]# createrepo -v /oracle/repo/

mkdir -p /oracle/repo/repodata

cp *    /oracle/repo/

cp /media/cdrom/repodata/*comps*.xml  /oracle/repo/repodata

cd /oracle/repo/

[root@erp-ides repo]# createrepo -v /oracle/repo/

root@erp-ides yum.repos.d]#vi  rhel65.repo

[rhel65]

name=RHEL 6.5

baseurl=file:///oracle/repo

gpgcheck=0

enabled=1

root@erp-ides cdrom]#  yum clean all

[root@erp-ides cdrom]# yum list

upgrade from 10.2.0.1 to 11.2.0.3

1-use the link 

http://bedirisendiri.blogspot.co.uk/2012/10/upgrade-10201-to-11203.html

2-patches name are 

                                 10.2.0.4 (patch 6810189)

                                 11.2.0.3 (patch 10404530)

install oracle cloud control 12c R4

sap links to blogs-books-tutorials

Below are some links for some sap which  are very useful for sap basis admin:

Blogs

====

http://basishowto.blogspot.co.uk/

http://basishowto.blogspot.co.uk/

http://sapbasis-tutorial.blogspot.co.uk/

http://sapbasistechnical.blogspot.co.uk/

http://sapsharing.blogspot.co.uk/

http://sureshchowdarysapbasiss.blogspot.co.uk/

Books

=======

http://www.4shared.com/folder/ka9bwjR-/_online.html

tutorials

=======

http://www.guru99.com/sap-basis-training-tutorials.html

http://sapbasiskapilpatil.blogspot.co.uk/

http://www.saponlinetutorials.com/sap-fico-module-training-tutorials-sap-fi-materials/

videos

======

https://www.youtube.com/watch?v=zc5UI6SUOt4

ORA-39700

problem

=======

1-i was asked for incomplete rman restore , after the restore and recovery ,i tried to open the db restore logs, the instance crashed with the following errors:

RMAN>  run {alter database open resetlogs; }

using target database control file instead of recovery catalog

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00601: fatal error in recovery manager

RMAN-03004: fatal error during execution of command

ORA-03114: not connected to ORACLE

RMAN-03002: failure of alter db command at 04/20/2015 15:54:49

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

Process ID: 27721760

Session ID: 1 Serial number: 453

ORACLE error from target database: 

ORA-03114: not connected to ORACLE

explanation

=========

the db was upgraded put the backup was before the upgrade

solution

======

upgrade the db to open it 

SQL> STARTUP UPGRADE

SQL> @?/rdbms/admin/catupgrd.sql 

SQL> STARTUP 

SQL> @?/rdbms/admin/utlrp.sql

some oracle errors

sources	solution	error
metalink Doc ID 756799.1	as per metalink Doc ID 756799.1  this is due Bug 6767655 and fixed in 10.2.0.5 (Server Patch Set) And the  Workaround is  Avoid concurrent DML and index rebuild online.  Serialize these operations	ORA-07445: exception encountered: core dump [kauxs_do_journal()+4] [SIGSEGV] [Address not mapped to object] [0x000000002] [] []
(Doc ID 293002.1)	cause ~~~~~~~~ The "UPGRADE CATALOG" step list in the patch or patchset readme was not submitted. This could leave the recovery catalog schema in a version lower than 9.2.0.4.0. Fix ~~~~~ Connect to the target and the catalog database then run "UPGRADE CATALOG". Re-enter "UPGRADE CATALOG" a second time when prompted. If "RESYNC CATALOG" then runs without errors the issue should be resolved. resync catalog; RMAN> upgrade catalog; # twice to confir	RMAN-03014 implicit resync of recovery catalog failed
Doc ID 1312448.1		RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on B1 channel at 10/26/2014 12:56:48 ORA-19513: failed to identify sequential file ORA-27206: requested file not found in media management catalog

TNS-12502 Tips

Cause:  No CONNECT_DATA was passed to the listener.

Action:  Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor.

ORA-1578

error

===

db corruption

SQL> select * from scott.dept_view;
select * from scott.dept_view
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 11, block # 34)
ORA-01110: data file 5: '/home/oracle/oradata/users.dbf'

solution

=====

follow metalink DBMS_REPAIR example (Doc ID 68013.1)

sources

=====

How to identify the corrupt Object reported by ORA-1578 / RMAN / DBVERIFY (Doc ID 819533.1)

RMAN-20033

Error

=======

Rman backup failed with error 

Starting Control File and SPFILE Autobackup at Dec 13 13 12:59:20

piece handle=ORA_CFc-6717079-20131213-10 comment=API Version 2.0,MMS Version 4.2.0.0

Finished Control File and SPFILE Autobackup at Dec 13 13 13:00:29

released channel: B1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03008: error while performing automatic resync of recovery catalog

RMAN-20033: control file sequence# too

explanation

==========

2 rman backups running at the same time ,kill all the rman session and restart the backup again 

ORA-19550

Error:

===

Rman backup fail with :

using target database control file instead of recovery catalog

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of allocate command on B1 channel at 04/15/2015 10:11:01

ORA-19550: cannot use backup/restore functions while using dispatcher

Explanation

========

Doc ID 215934.1

Solution

=======

Create a new TNS alias with SERVER=DEDICATED in the TNSNAMES.ORA file and use 
this alias to connect to the target database.

Example

=======

SHAGGY =  (DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT =1521)))(CONNECT_DATA=(SERVICE_NAME =SHAGGY)(server =dedicated)    )  )

Sources

======

metalink Doc ID 215934.1

http://grokbase.com/t/freelists.org/oracle-l/01ck765az2/how-to-backup-mts-database-with-rman

Becoming ORALCE DBA

1-This career path need a lot of patient reading always read when you have time read ,reading  and practice is the BREAD of this Career Path

2-The following link give you the available choices in the admin

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=213&path=DBAN&columnNumber=5

3- you will get these courses by self study or taking courses and then begin practice

4-you must build your own lab ,you can use the following link

     http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=213&path=DBAN&columnNumber=5

5-  if you have any quesyion email me