Amazon books

Monday, December 3, 2012

Some LOGDUMP commands for Golden Gate


--LOGDUMP Golden Gate

--View file header
Logdump 1> fileheader on

--View record header
Logdump 1> ghdr on

--Add column information
Logdump 1> detail on

--Add HEX and  ASCII data values to column list
Logdump 1> detail data

--To control how much record data is displayed
Logdump 1> reclen 280

--Go to first record
Logdump 1> pos 0
Logdump 1> next (or just type n)

--Position to aproximate RBA
Logdump 1> pos
Logdump 1> scanforheader (or just type sfh) --Go to next header

--Count records in trail
Logdump> count

--Filtering including a file name
Logdump> filter include filename TCUST*
Logdump> filter match all
Logdump> n

--Locating a Hex Data Value
Logdump> filter inc hex /7776543/
Logdump> pos 0
Logdump> n


--Save records from the current position to a new trail file
Logdump> save newtrail 10 records

--Create a log for your session
Logdump> log to temp1_session.log

--Stop logging
Logdump> log stop

Best Regards,
Paulo Portugal

Thursday, November 29, 2012

Some ILOM commands

--List hard disks
show -l all /SYS type=='Hard Disk'

--Show all temperatures
show -level all -output table /SYS type==Temperature value

--Show network configuration
show /SP/network/

--Start server
start /SYS

--Stop Server
stop [-force] /SYS

--Turn on LED
set /SYS/LOCATE value=Fast_Blink

--Turn off LED
set /SYS/LOCATE value=Off

--Show System information
show /SYS

Thursday, November 22, 2012

Erro ORA-12528 connecting to AUXILIARY Instance - RMAN Duplicate Database

If your database is in nomount, listener will show status as BLOCKED and to connect to this NOMOUNT database from a remote server you need to add (UR=A) in remote tnsnames.ora file as on example below:


DBNEW =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)(QUEUESIZE = 90))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBNEW.WORLD) (UR=A)
    )
  )




Wednesday, October 10, 2012

RMAN Backup to DISK and TAPE on same RUN block


This backup will do a disk and tape backup on same block using the TAG from disk backup:

run{
crosscheck archivelog all;
crosscheck backup;
backup
 device type disk incremental level 0
 format '+ORAPRD_RECO'
 database
 tag 'SEMANAL_ORAPRD';
backup device type sbt backupset from tag  'SEMANAL_ORAPRD';
backup device type disk current controlfile format '+ORAPRD_RECO';
backup device type sbt current controlfile format 'BKP_CTL_SEMANAL_ORAPRD_%U';
}

Best Regards,
Paulo Portugal

Create and Registering ACFS windows RAC


1-Create ACFS:

D:\ORACLE\11.2.0\grid\BIN\acfsformat.exe /b 4k \\.\asm-scripts-20


2-Register ACFS created:

D:\ORACLE\11.2.0\grid\BIN\acfsutil.exe registry /a /f \\.\asm-scripts-20 D:\ORACLE\ACFS\SCRIPTS


Best Regards,
Paulo Portugal

Change ACFS mount point! ACFSDISMOUNT ACFSMOUNTVOL and ACFSUTIL


The steps to change ACFS mount point that I used was:

--Dismount old mount point
--Dismount
D:\ORACLE\11.2.0\grid\BIN>acfsdismount D:\ORACLE\ACFS\SCRIPTS

--Mount in new directory (Create the new directory before this step)
D:\ORACLE\11.2.0\grid\BIN>acfsmountvol /v  D:\ORACLE\ACFS\ZSCRIPTS  asm-scripts-20
acfsmountvol: volume: asm-scripts-20, ponto de montagem: D:\ORACLE\ACFS\ZSCRIPTS
acfsmountvol: verificando o estado do volume
acfsmountvol: criando o ponto de montagem
acfsmountvol: Montado com sucesso D:\ORACLE\ACFS\ZSCRIPTS.

--Unregister old mount point and register new one using commands below:
acfsutil registry /d asm-scripts-20
acfsutil registry /a asm-scripts-20 D:\ORACLE\ACFS\ZSCRIPTS

OBS: /d (DELETE)  /a (ADD)

Best Regards,
Paulo Portugal

Wednesday, October 3, 2012

ORA-15505: cannot start workload capture because instance 1 encountered errors

When starting CAPTURE got this error:

SYS@dborig> BEGIN
dbms_workload_capture.start_capture(UNISTR('CAPTURE-dborig-20120908132124'), UNISTR('DATA_PUMP_DIR'), NULL, 'INCLUDE', FALSE);
END;  2    3 
  4  /
BEGIN
*
ERROR at line 1:
ORA-15505: cannot start workload capture because instance 1 encountered errors
while accessing directory "/u01/app/oracle/product/11.2.0/db_1/rdbms/log/"
ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 811
ORA-06512: at line 2

---SOLUTION:
Create a new DIRECTORY object in an empty directory on your file system.

Run dbms_workload_capture.start_capture again.

Best Regards,
Paulo Portugal

CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888.

Error when trying to run any command at CELLCLI prompt.

To fix that, check if your MS is running. Check error logs in /opt/oracle/cell/log/diag/asm/cell/trace/ms-odl.log file.

Restart your MS using commands below:


[root@cell1 init.d]# ./celld status
     rsStatus:               running
     msStatus:               running
     cellsrvStatus:          running
[root@cell1 init.d]# ./celld stop

Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.
[root@cell1 init.d]# ./celld start

Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...
 running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.
[root@cell1 init.d]# ./celld status
     rsStatus:               running
     msStatus:               running
     cellsrvStatus:          running
[root@cell1 init.d]#


Best Regards,
Paulo Portugal

Wednesday, April 25, 2012

Create and Start Oracle 11g R2 NoSQL Database


1-Download file kv-1.2.123.zip and unzip it to your windows folder

2-Install using the command below:
C:\Users\portugal\Downloads\kv-1.2.123\lib>"C:\Program Files (x86)\Java\jre6\bin\java.exe" -jar kvclient-1.2.123.jar
11gR2.1.2.123

3-Configure using command below:
C:\Users\portugal\Downloads\kv-1.2.123\lib>"C:\Program Files (x86)\Java\jre6\bin\java.exe" -jar kvstore-1.2.123.jar make
bootconfig -root c:\KVROOT -port 5000 -admin 5001 -host portugal-laptop -harange 5010,5020

4-Start using this command:

C:\Users\portugal\Downloads\kv-1.2.123\lib>"C:\Program Files (x86)\Java\jre6\bin\java.exe" -jar kvstore-1.2.123.jar star
t -root c:\KVROOT&

5-Access using http://hostname:5001

Best Regards,
Paulo Portugal

Friday, April 13, 2012

Oracle High Availability Service has problems on this hosts. Verifying CRS integrity ,,ERROR: ,User equivalence unavailable on all the nodes.,Verification cannot proceed.,,,Verification of CRS integrity was unsuccessf

If you are getting Grid alerts like "Oracle High Availability Service has problems on this hosts. Verifying CRS integrity ,,ERROR: ,User equivalence unavailable on all the nodes.,Verification cannot proceed.,,,Verification of CRS integrity was unsuccessf"

Configure user equivalence for agent OS owner running script sshUserSetup.sh from agent home like below:

###################################################################################################################
[oraag12c@bwmdsp03 u01]$ ./core/12.1.0.1.0/oui/prov/resources/scripts/sshUserSetup.sh -user oraag12c -hosts "bwmdsp03 bwmdsp04 bwmdsp08 bwmdsp09" -usePassphrase 123mudar -noPromptPassphrase
The output of this script is also logged into /tmp/sshUserSetup_2012-04-13-21-15-30.log
Hosts are bwmdsp03 bwmdsp04 bwmdsp08 bwmdsp09
user is oraag12c
Platform:- Linux
Checking if the remote hosts are reachable
PING bwmdsp03.b2w (192.168.201.111) 56(84) bytes of data.
64 bytes from bwmdsp03.b2w (192.168.201.111): icmp_seq=1 ttl=64 time=0.018 ms
64 bytes from bwmdsp03.b2w (192.168.201.111): icmp_seq=2 ttl=64 time=0.017 ms
64 bytes from bwmdsp03.b2w (192.168.201.111): icmp_seq=3 ttl=64 time=0.032 ms
64 bytes from bwmdsp03.b2w (192.168.201.111): icmp_seq=4 ttl=64 time=0.032 ms
64 bytes from bwmdsp03.b2w (192.168.201.111): icmp_seq=5 ttl=64 time=0.053 ms

--- bwmdsp03.b2w ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4000ms
rtt min/avg/max/mdev = 0.017/0.030/0.053/0.013 ms
PING bwmdsp04.b2w (192.168.201.112) 56(84) bytes of data.
64 bytes from bwmdsp04.b2w (192.168.201.112): icmp_seq=1 ttl=64 time=0.114 ms
64 bytes from bwmdsp04.b2w (192.168.201.112): icmp_seq=2 ttl=64 time=0.123 ms
64 bytes from bwmdsp04.b2w (192.168.201.112): icmp_seq=3 ttl=64 time=0.102 ms
64 bytes from bwmdsp04.b2w (192.168.201.112): icmp_seq=4 ttl=64 time=0.098 ms
64 bytes from bwmdsp04.b2w (192.168.201.112): icmp_seq=5 ttl=64 time=0.100 ms

--- bwmdsp04.b2w ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 3999ms
rtt min/avg/max/mdev = 0.098/0.107/0.123/0.013 ms
PING bwmdsp08.b2w (192.168.201.114) 56(84) bytes of data.
64 bytes from bwmdsp08.b2w (192.168.201.114): icmp_seq=1 ttl=64 time=0.216 ms
64 bytes from bwmdsp08.b2w (192.168.201.114): icmp_seq=2 ttl=64 time=0.160 ms
64 bytes from bwmdsp08.b2w (192.168.201.114): icmp_seq=3 ttl=64 time=0.158 ms
64 bytes from bwmdsp08.b2w (192.168.201.114): icmp_seq=4 ttl=64 time=0.340 ms
64 bytes from bwmdsp08.b2w (192.168.201.114): icmp_seq=5 ttl=64 time=0.167 ms

--- bwmdsp08.b2w ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 3999ms
rtt min/avg/max/mdev = 0.158/0.208/0.340/0.069 ms
PING bwmdsp09.b2w (192.168.201.115) 56(84) bytes of data.
64 bytes from bwmdsp09.b2w (192.168.201.115): icmp_seq=1 ttl=64 time=0.171 ms
64 bytes from bwmdsp09.b2w (192.168.201.115): icmp_seq=2 ttl=64 time=0.259 ms
64 bytes from bwmdsp09.b2w (192.168.201.115): icmp_seq=3 ttl=64 time=0.158 ms
64 bytes from bwmdsp09.b2w (192.168.201.115): icmp_seq=4 ttl=64 time=0.180 ms
64 bytes from bwmdsp09.b2w (192.168.201.115): icmp_seq=5 ttl=64 time=0.174 ms

--- bwmdsp09.b2w ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4000ms
rtt min/avg/max/mdev = 0.158/0.188/0.259/0.038 ms
Remote host reachability check succeeded.
The following hosts are reachable: bwmdsp03 bwmdsp04 bwmdsp08 bwmdsp09.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
The script will setup SSH connectivity from the host bwmdsp03 to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host bwmdsp03
and the remote hosts without being prompted for passwords or confirmations.

NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.

NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.

Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes

The user chose yes
User chose to skip passphrase related questions.
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oraag12c/.ssh/config, it would be backed up to /home/oraag12c/.ssh/config.backup.
Removing old private/public keys on local host
Running SSH keygen on local host with empty passphrase
Generating public/private rsa key pair.
Your identification has been saved in /home/oraag12c/.ssh/id_rsa.
Your public key has been saved in /home/oraag12c/.ssh/id_rsa.pub.
The key fingerprint is:
9c:6c:1a:03:02:0e:65:1b:62:f2:03:ff:c1:88:a8:0e oraag12c@bwmdsp03
Creating .ssh directory and setting permissions on remote host bwmdsp03
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oraag12c. THIS IS AN SSH REQUIREMENT.
The script would create ~oraag12c/.ssh/config file on remote host bwmdsp03. If a config file exists already at ~oraag12c/.ssh/config, it would be backed up to ~oraag12c/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host bwmdsp03.
Warning: Permanently added 'bwmdsp03,192.168.201.111' (RSA) to the list of known hosts.
oraag12c@bwmdsp03's password:
Done with creating .ssh directory and setting permissions on remote host bwmdsp03.
Creating .ssh directory and setting permissions on remote host bwmdsp04
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oraag12c. THIS IS AN SSH REQUIREMENT.
The script would create ~oraag12c/.ssh/config file on remote host bwmdsp04. If a config file exists already at ~oraag12c/.ssh/config, it would be backed up to ~oraag12c/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host bwmdsp04.
Warning: Permanently added 'bwmdsp04,192.168.201.112' (RSA) to the list of known hosts.
oraag12c@bwmdsp04's password:
Done with creating .ssh directory and setting permissions on remote host bwmdsp04.
Creating .ssh directory and setting permissions on remote host bwmdsp08
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oraag12c. THIS IS AN SSH REQUIREMENT.
The script would create ~oraag12c/.ssh/config file on remote host bwmdsp08. If a config file exists already at ~oraag12c/.ssh/config, it would be backed up to ~oraag12c/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host bwmdsp08.
Warning: Permanently added 'bwmdsp08,192.168.201.114' (RSA) to the list of known hosts.
oraag12c@bwmdsp08's password:
Done with creating .ssh directory and setting permissions on remote host bwmdsp08.
Creating .ssh directory and setting permissions on remote host bwmdsp09
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oraag12c. THIS IS AN SSH REQUIREMENT.
The script would create ~oraag12c/.ssh/config file on remote host bwmdsp09. If a config file exists already at ~oraag12c/.ssh/config, it would be backed up to ~oraag12c/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host bwmdsp09.
Warning: Permanently added 'bwmdsp09,192.168.201.115' (RSA) to the list of known hosts.
oraag12c@bwmdsp09's password:
Done with creating .ssh directory and setting permissions on remote host bwmdsp09.
Copying local host public key to the remote host bwmdsp03
The user may be prompted for a password or passphrase here since the script would be using SCP for host bwmdsp03.
oraag12c@bwmdsp03's password:
Done copying local host public key to the remote host bwmdsp03
Copying local host public key to the remote host bwmdsp04
The user may be prompted for a password or passphrase here since the script would be using SCP for host bwmdsp04.
oraag12c@bwmdsp04's password:
Done copying local host public key to the remote host bwmdsp04
Copying local host public key to the remote host bwmdsp08
The user may be prompted for a password or passphrase here since the script would be using SCP for host bwmdsp08.
oraag12c@bwmdsp08's password:
Done copying local host public key to the remote host bwmdsp08
Copying local host public key to the remote host bwmdsp09
The user may be prompted for a password or passphrase here since the script would be using SCP for host bwmdsp09.
oraag12c@bwmdsp09's password:
Done copying local host public key to the remote host bwmdsp09
The script will run SSH on the remote machine bwmdsp03. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
The script will run SSH on the remote machine bwmdsp04. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
The script will run SSH on the remote machine bwmdsp08. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
The script will run SSH on the remote machine bwmdsp09. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
cat: /home/oraag12c/.ssh/known_hosts.tmp: No such file or directory
cat: /home/oraag12c/.ssh/authorized_keys.tmp: No such file or directory
SSH setup is complete.

------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oraag12c.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oraag12c or ~oraag12c/.ssh on the remote host may not be owned by oraag12c.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the /sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--bwmdsp03:--
Running /usr/bin/ssh -x -l oraag12c bwmdsp03 date to verify SSH connectivity has been setup from local host to bwmdsp03.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
The script will run SSH on the remote machine bwmdsp03. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
Fri Apr 13 21:16:31 BRT 2012
------------------------------------------------------------------------
--bwmdsp04:--
Running /usr/bin/ssh -x -l oraag12c bwmdsp04 date to verify SSH connectivity has been setup from local host to bwmdsp04.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
The script will run SSH on the remote machine bwmdsp04. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
Fri Apr 13 21:16:31 BRT 2012
------------------------------------------------------------------------
--bwmdsp08:--
Running /usr/bin/ssh -x -l oraag12c bwmdsp08 date to verify SSH connectivity has been setup from local host to bwmdsp08.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
The script will run SSH on the remote machine bwmdsp08. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
Fri Apr 13 21:16:31 BRT 2012
------------------------------------------------------------------------
--bwmdsp09:--
Running /usr/bin/ssh -x -l oraag12c bwmdsp09 date to verify SSH connectivity has been setup from local host to bwmdsp09.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
The script will run SSH on the remote machine bwmdsp09. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
Fri Apr 13 21:16:31 BRT 2012
------------------------------------------------------------------------
SSH verification complete.
[oraag12c@bwmdsp03 u01]$ cd /opt/oracle/products/crs/bin/
[oraag12c@bwmdsp03 bin]$ ./cluvfy comp crs -n bwmdsp03,bwmdsp04

Verifying CRS integrity

Checking CRS integrity...

Checking daemon liveness...
Liveness check passed for "CRS daemon".

Checking daemon liveness...
Liveness check passed for "CSS daemon".

Checking daemon liveness...
Liveness check passed for "EVM daemon".

Checking CRS health...
CRS health check passed.

CRS integrity check passed.

Verification of CRS integrity was successful.
###################################################################################################################


Best Regards,
Paulo Portugal

Tuesday, April 10, 2012

How to change Grid Control Repository Database from Single Instance to RAC

1-Run command below using your RAC information in all OMS nodes:

emctl config oms -store_repos_details -repos_conndesc '(DESCRIPTION=
(ADDRESS_LIST=(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=host01-vip)(PORT=1523))
(ADDRESS=(PROTOCOL=TCP)(HOST=host02-vip)(PORT=1523)))
(CONNECT_DATA=(SERVICE_NAME=SERVDB)))' -repos_user sysman -repos_pwd secret


2-Check new configuration using this command below:
emctl config oms -list_repos_details

3-Restart OMS

Best Regards,
Paulo Portugal

Friday, March 16, 2012

SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

If getting this error using addbctl.sh script to start or stop database after a migration, or even if is just using SQLPLUS and got this error below:

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly


Just UNSET the ORA_TZFILE variable.

I added this line below in my .env file:

unset ORA_TZFILE

Best Regards,
Paulo Portugal

Monday, March 5, 2012

FRM-92120 Registry.dat is missing

Just install User-Agent switcher (https://chrome.google.com/webstore/detail/djflhoibgkdhkhhcedjiklpkjnoahfmg/related?hl=en-US&gl=US) and check "Mac Safari 4" and try again.

This works for me.

Best Regards,
Paulo Portugal

Thursday, March 1, 2012

REP-56055: Exceed max connections allowed: 20

Go to your Oracle Reports server and change file $ORACLE_HOME/reports/conf/ like below:

--OLD VALUE:




--NEW VALUE





Restart iAS.

opmnctl stopall
opmnctl startall

Best Regards,
Paulo Portugal

Saturday, January 7, 2012

Undo segments status is PARTLY AVAILABLE

Alert log shows:

SMON: about to recover undo segment 309
SMON: mark undo segment 309 as available
SMON: about to recover undo segment 312
SMON: mark undo segment 312 as available
SMON: about to recover undo segment 40


To fix:

Check which segments have status PARTLY AVAIABLE and if you do not have any in-doubt transaction (dba_2pc_pending , v$transaction, etc) them:

alter rollback segment XXXXX online;

Best Regards,
Paulo Portugal