For the people who think differently Welcome aboard
zfs create -o mountpoint=/u01 rpool/u01
EM12c R2: How to Upgrade to EM 12c R2 – Two System Method [ID 1363162.1]
EM12c: How to install JVM Diagnostics (JVMD) in Cloud Control [ID 1493862.1]
EM12c: How To Upgrade Plugin On 12.1 Management Agent [ID 1490762.1]
How to Install 12c Agent on Virtual Host [ID 1469995.1]
EM12c Upgrade : Agents Are Not Listed in the Upgrade Console With Error Inventory Data Is Missing From the Repository [ID 1489109.1]
EM 12c : How to Discover All Targets On a Single Host After Agent Installation ? [ID 1386817.1]
EM 12c : Understanding Promote Target Functionality [ID 1386161.1]
EM12c How to Perform Automatic Host Discovery Using IP Scan Method ? [ID 1386811.1]
EM12c Agent status Fails With “Peer Not Authenticated” Error. [ID 1510706.1]
EM12C: Agent Installation Failed With Error: “OMS_HOST and EM_UPLOAD_PORT is not active” [ID 1371873.1]
How To Upgrade Java Diagnostics In Enterprise Manager 12c With the Latest Patches [ID 1534023.1]
EM12c Cloud Control: Required Patches for Discovery and Monitoring of Coherence Targets [ID 1526316.1]
EM12c : Patch Conflict While Applying Patch 14040891 [ID 1479092.1]
Unable To Add host targets with EM12c – Valid Host Name check fails [ID 1433843.1]
Release Schedule of Current Enterprise Manager Releases and Patch Sets (10g, 11g, 12c) [ID 793512.1]
EM 12c: How to Deploy a Plug-In from Enterprise Manager Cloud Control 12.1.0.1 [ID 1364030.1]
Thank you
Osama Mustafa
By default root login on solaris disabled and you cannot login as root. ( which is amazing for security ) but sometimes you need to enable this login and to do that follow the below steps :
#
# The system provided entries are stored in different files
# under “/etc/user_attr.d”. They should not be copied to this file.
#
# Only local changes should be stored in this file.
# This line should be kept in this file or it will be overwritten.
#
oracle::::type=normal;project=user.oracle;defaultpriv=basic,net_privaddr
type should be normal.
and to enable SSH for root user you have to do the following :
vi /etc/ssh/sshd_config
PermitRootLogin = yes
vi /etc/default/login
#CONSOLE =/dev/login|console
rolemod -K type=normal root
Thank you
Osama mustafa
zfs create -V 1gb rpool/newtmp
swap -a /dev/zvol/dsk/rpool/newtmp
Old Size :
swap 159M 212K 159M 1% /tmp
rpool/export 78G 32K 67G 1% /export
rpool/export/home 78G 32K 67G 1% /export/home
rpool/export/home/omnix
78G 790K 67G 1% /export/home/omnix
oracle 118G 1.1M 11G 1% /oracle
rpool 78G 39K 67G 1% /rpool
oracle/u01 118G 93G 25G 79% /u01
/oracle 11G 1.1M 11G 1% /home/oracle
New Size :
root@HMMDB:/# zfs create -V 1gb rpool/extraswap
root@HMMDB:/# zfs list
NAME USED AVAIL REFER MOUNTPOINT
oracle 107G 10.6G 1.11M /oracle
oracle/u01 92.6G 25.0G 92.6G /u01
rpool 12.6G 65.6G 39K /rpool
rpool/ROOT 5.39G 65.6G 31K legacy
rpool/ROOT/solaris 5.39G 65.6G 5.03G /
rpool/ROOT/solaris/var 316M 65.6G 312M /var
rpool/dump 1.03G 65.7G 1.00G –
rpool/export 854K 65.6G 32K /export
rpool/export/home 822K 65.6G 32K /export/home
rpool/export/home/omnix 790K 65.6G 790K /export/home/omnix
rpool/extraswap 1.03G 66.7G 16K –
rpool/swap 5.16G 65.8G 5.00G –
root@HMMDB:/# swap -a /dev/zvol/dsk/rpool/extraswap
Now Check New Size for /tmp
swap 1.2G 212K 1.2G 1% /tmp
rpool/export 78G 32K 66G 1% /export
rpool/export/home 78G 32K 66G 1% /export/hom
Thank you
Osama Mustafa
SQL > SELECT START_SCN,OPERATION,LOGON_USER,XID FROM FLASHBACK_TRANSACTION_QUERY WHERE TABLE_NAME=’TEST’;
The Output will be like this :
XID TABLE_OWNER TABLE_NAME OPERATION LOGON_USER UNDO_SQL
—————- ———– ———- ——————————– ———- —————
0600090064030000 TX UNKNOWN TEST
0600090064030000 TX UNKNOWN TEST
To avoid Unknown Status enable supplemental logging by
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA ;
Database altered.
Thank you
Osama mustafa
Edit the files /etc/vsftpd.ftpusers and /etc/vsftpd.user_list looks like :
#
# List of users denied access to the FTP server, see ftpusers(4).
#
root
daemon
bin
sys
adm
lp
uucp
nuucp
dladm
netadm
netcfg
smmsp
xvm
mysql
openldap
webservd
nobody
noaccess
nobody4
unknown
zfssnap
aiuser
and remove root user from each file.
You can control ftp as services from
/etc/init.d/vsftpd
Thank you
Osama Mustafa
ORA-00600: internal error code, arguments: [4193], [4271], [4056], [], [], [], [], []
SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– ——————————
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS
SQL> alter system set undo_management=’MANUAL’ scope=spfile;
SQL > Shutdown immediate ;
SQL > Startup ;
SQL > create undo tablespace NEW_UNDOTBS datafile ‘/u01/app/oracle/oradata/SID/NEW_UNDOTBS01.DBF’ size 1G ;
SQL> alter system set undo_tablespace=’NEW_UNDOTBS’ scope=spfile;
System altered.
SQL> alter system set undo_management=’AUTO’ scope=spfile;
System altered.
SQL> drop tablespace UNDOTBS01 including contents;
ORA-01548: active rollback segment ‘_SYSSMU1_1255349037$’ found, terminate dropping tablespace
SQL> select * from v$rollname ;
USN NAME
———- —————–
0 SYSTEM
1 _SYSSMU1$
2 _SYSSMU2$
3 _SYSSMU3$
4 _SYSSMU4$
5 _SYSSMU5$
6 _SYSSMU6$
SQL > Create Pfile=’/u01/New.init’ from spfile
File Created
SQL > Shutdown immediate ;
*.undo_management=’MANUAL’
*.undo_retention=1800
*.undo_tablespace=’NEW_UNDOTBS’
*._offline_rollback_segments= (_SYSSMU1$,_SYSSMU2$,_SYSSMU3$,_SYSSMU4$,_SYSSMU5$,_SYSSMU6$ )
to solve this :
Setup >> Extensibility >> Self Update
Connection mode should be Offline ( you need to configure System Library to change Connection mode or Error will be appeared )
After change Connection mode to offline back to self_update main screen And Press Check Updates
You need to visit https://support.oracle.com and download patch number 9348486 after finish downloading copy to OMS server using FTP and don’t unzip it.
Run the below command
./emcli import_update_catalog -file=/u01/p9348486_112000_Generic.zip -omslocal
if the below error show up :
Error: The command name “import_update_catalog” is not a recognized command.
Run the “help” command for a list of recognized commands.
You may also need to run the “sync” command to synchronize with the current OMS.
./emcli login -username=’SYSTEM’
Enter password
Login successful
./emcli sync
Synchronized successfully
./emcli import_update_catalog -file= …..
Thank you
Osama Mustafa
Database 11gr2
Rac 11gr2
When trying to expdp the below error appear :
expdp dumpfile=tdmp_test.dmp logfile=1.log directory=expdp_folder schemas=siebel parallel=4
ORA-31693: Table data object “CS_XM_TEMP”.”CS_XM_TEMP_CC” failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/u01/expdp /dump_test.dmp” for write
ORA-19505: failed to identify file “/u01/expdp/dump_test.dmp”
ORA-27037: unable to obtain file status
You need to make sure of the below :
– Folder exdp_folder should be exists on the both nodes with same path.
even if you try to connect using tnsnames it will generate error so solution
-Remove parallel from your expdp command to be like this
expdp dumpfile=tdmp_test.dmp logfile=1.log directory=expdp_folder schemas=siebel
-Use Cluster Option in expdp
expdp dumpfile=tdmp_test.dmp logfile=1.log directory=expdp_folder schemas=siebel cluster=n
Thank you
Osama mustafa
Technology Geek 