Sharepoint page title change from ‘Basic page’

Sharepoint 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 file, look for text like this:

<asp:Content ContentPlaceHolderId="PlaceHolderPageTitle" runat="server">
    <SharePoint:ListFormPageTitle runat="server"/>
</asp:Content >

Take out:

<SharePoint:ListFormPageTitle runat="server"/>

and put in your own title. So you end up with something like this:

<asp:Content ContentPlaceHolderId="PlaceHolderPageTitle" runat="server">
    My Page Title
</asp:Content>

You may instead see text like this:

<asp:Content ContentPlaceHolderId="PlaceHolderPageTitle" runat="server">
    <SharePoint:EncodedLiteral runat="server" text="<%$Resources:wss,webpagecreation_bp_title%>" EncodeMethod='HtmlEncode'/>
</asp:Content>

If so, take out:

text="<%$Resources:wss,webpagecreation_bp_title%>"

and put in your own title. So you end up with something like this:

<asp:Content ContentPlaceHolderId="PlaceHolderPageTitle" runat="server">
    <SharePoint:EncodedLiteral runat="server" text="My Page Title" EncodeMethod='HtmlEncode'/>
</asp:Content>

(From Answer 22 at http://www.go4answers.com/Example/change-page-title-page-already-created-63446.aspx)

Posted in Sharepoint | 1 Comment

IBM Tivoli restores using dsmc

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
Posted in Linux, Rman | Leave a comment

Windows Server 2008 R2 Firewall for SQL Server and FTP

Windows 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 the below changes are made:

1) Running FTP (client) from server command prompt will allow you to connect out to an FTP site, but any ‘ls‘ or ‘get‘ commands will hang.

To resolve this, first set firewall notification on:

Start > Administrative Tools > Server Manager > Configuration > Windows Firewall with Advanced Security > Windows Firewall Properties (also available with a right click) > click on the ‘Domain Profile’ tab – ‘settings’ section – ‘customize’ button > Change ‘Display a notification’ to ‘yes’ > click ‘ok’ twice for changes to take effect.

Now go to a command prompt window and start ftp client session and try ‘ls’. It will still hang, but this time a window will prompt if you want to unblock ftp client:

Click the ‘Allow Access’ button.

Now any new ftp client sessions will work ok. You can test that by opening a second command window and running ftp again.

At this stage, you can set the firewall notification back to ‘off’, if you want.

2) To allow “SQL Server Management Studio” connections from e.g. your PC into the server, add a rule for port 1433 to the database server firewall, with :-

Start > Administrative Tools > Server Manager > Configuration > Windows Firewall with Advanced Security > Inbound Rules > (right click) > New Rule

Rule Type: change to ‘Port’

‘Protocols and Ports’: Keep with ‘TCP’, but specify ‘Specific local ports’ – 1433

Accept defaults with the other screens, except give the rule a meaningful name and description.

Screenshots for this below.

Continue reading

Posted in Installs, SQL server, Windows | 2 Comments

Remove dba_2pc_pending records

Old 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
Posted in Scripts | Leave a comment

Easy connect database links

Saves 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.

Posted in Database links | Leave a comment

RAC OCFS on 11gR2

http://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

 

 

 

 

Posted in RAC | Leave a comment

Server age with dmidecode|grep Date

BIOS build date should correspond to approximate manufacture date for a server, is given with (as root):
dmidecode | egrep -i 'date|product'

Posted in Linux | Leave a comment

Recover RAC database

RAC 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
Posted in RAC | Leave a comment

Remove a parameter entry from spfile

alter 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.

Posted in Spfile | Leave a comment

Find delete old files

#  Delete files older than 15 minutes
find /ORA_DISK/redoarch/ -name 'arch_*.dbf' -mmin +15 -delete

#Delete files older than 2 days
50 8 * * * find /ORA_DISK/redoarch/ -name 'arch_*.dbf' -mtime +2 -delete

Old versions of unix find do not have the -delete option, so instead:

#  Delete files older than 15 minutes
find /ORA_DISK/redoarch/ -name 'arch_*.dbf' -mmin +15 -exec rm {} \;

#Delete files older than 2 days
50 8 * * * find /ORA_DISK/redoarch/ -name 'arch_*.dbf' -mtime +2 -exec rm {} \;
Posted in Linux, Rman, Scripts | Leave a comment