Files /etc/hosts.allow and /etc/hosts.deny control tcp wrapper permissions for incoming requests to linux servers. Ftp access is normally controlled by the ‘vsftpd’ line, e.g.: vsftpd: 138.134.116. 138.134.117. That would allow ftp connections from IP addresses like 138.134.116.x and 138.134.117.x. If your IP address is not in the allow list, ftp attempts will fail with an […]
Read More FTP 421 service not available tcp wrapper hosts.allowSharepoint displays ‘Basic page’ in the browser title bar for any basic pages. To change, directly edit the .aspx file in windows explorer. To ge to that, use e.g. Start > Run and paste in the address of your sharepoint site which you can take from its URL, something like: ‘\\myspserver.mydomain.com\root\documentation\myteam\Documents\’ When editing the .aspx […]
Read More Sharepoint page title change from ‘Basic page’As root dsmc or, for more complex configurations, specify an optfile: dsmc -optfile=/opt/tivoli/tsm/client/ba/bin/dsm-ora.opt List backup files: tsm> q backup “/oracle/*” -subdir=yes -inactive Restore: tsm> restore “/oracle/mydb/*” /oracle/ -subdir=yes -pick Note how the second mention of directory path ommits the lowest directory. tsm> + # to select all tsm> o # ok, start restore
Read More IBM Tivoli restores using dsmcWindows Server 2008 R2 has a strict firewall by default. It will not let you run FTP (client) from the server and get files from other servers/sites It will also not let you run “SQL Server Management Studio” from your PC and connect that into the instance running on the server. To fix this, apply […]
Read More Windows Server 2008 R2 Firewall for SQL Server and FTPOld entries in dba_2pc_pending can be removed by ‘rollback force’ or if that fails, with a purge: set pages 9999 spool go.tmp select ‘rollback force ”’||local_tran_id||”’ ;’ from dba_2pc_pending ; select ‘exec dbms_transaction.purge_lost_db_entry(”’||local_tran_id||”’ )’ , ‘commit;’ from dba_2pc_pending ; spool off
Read More Remove dba_2pc_pending recordsSaves modifying tnsnames.ora: create database link mylink connect to myuser identified by mypassword using ‘//myserver/mydatabase’ ; Note that passwords are case sensitive from 11g. This means 10g->11g links need uppercase passwords.
Read More Easy connect database linkshttp://learnwithme11g.wordpress.com/2010/03/19/11gr2-rac-shared-storage-preparationocfs-part2/ Also very good is http://www.oracledba.org/index.html /etc/init.d/o2cb enable (on both nodes) mkfs.ocfs2 -L “RAC8LUN” /dev/mapper/RAC8LUN1p1 mkfs.ocfs2 -L “RAC8Q” /dev/mapper/RAC8Qp1 vi /etc/fstab mkdir /CRS_DATA mkdir /ORA_DATA mount /dev/mapper/RAC8LUN1p1 mount /dev/mapper/RAC8Qp1
Read More RAC OCFS on 11gR2BIOS build date should correspond to approximate manufacture date for a server, is given with (as root): dmidecode | egrep -i ‘date|product’
Read More Server age with dmidecode|grep DateRAC has to be switched to non-cluster temporarily for the recovery. startup nomount alter system set cluster_database=false scope=spfile sid=’*’ ; shutdown immediate startup mount recover database alter database open ; alter system set cluster_database=true scope=spfile sid=’*’ ; shutdown immediate srvctl start database -d mydb
Read More Recover RAC databasealter system reset log_archive_start scope=spfile sid=’*’ ; Much better than old versions where you had to temporarily create a pfile, edit that, and load it in as an spfile.
Read More Remove a parameter entry from spfile