RSS Feed
TwitterRun $FND_TOP/bin/startmgr.sh you will need the password for the apps account. To check it is running, ps -ef | grep FNDLIBR via http://easyoracleapps.wordpress.com/2010/03/12/concurrent-managers/#more-99
Archive for the ‘Database’ Category
Posted in 
ORA-27121: unable to determine size of shared memory segment
August 8th, 2011 
Malcolm Chalmers If when you are trying to login to Oracle 10G on linux you get : ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux Error: 13: Permission denied This is caused by Oracle installer not setting setuid on $ORACLE_HOME/bin/oracle. To fix do: $ cd $ORACLE_HOME/bin $ chmod 6751 oracle via [...]
Changing a SQL database name
May 24th, 2011 Malcolm Chalmers 
USE master; alter database DB1_DEV set SINGLE_USER with rollback immediate go ALTER DATABASE DB1_DEV Modify Name = DB1; GO alter database DB1 set MULTI_USER go
Tags: Grid Control access to a Windows server
May 4th, 2011 Malcolm Chalmers 
If you are trying to get Grid Control to access a Windows server and having trouble here’s a few things to check. Check that the host name credentials you are providing are the same as the user who install the database software on the Windows server. Check that the user is a member of the [...]
Managing Oracle RMAN backups
May 3rd, 2011 Malcolm Chalmers 
Every now and again something will go screwy with my automatic RMAN backups and I’ll to find any that are expired or obsolete and delete them manually.
Creating a link between two SQL servers
March 30th, 2011 Malcolm Chalmers To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures. First, sp_addlinkedserver @server=’DBLINK01′,@srvproduct=”,@provider=’SQLOLEDB’,@datasrc=’SQL-HOU-01′; Where, @server is the name of the link @srvproduct is the type of product, by default SQL Server @datasrc is the server you link to Then, you need to set the username and password [...]
Manually adding a mail account to SQL2005/2008
March 30th, 2011 Malcolm Chalmers I was having trouble adding configuring Database Mail on a SQL2005 server today. I followed the wizard just like I had done on the previous 6 servers, but this one just didn’t want to add it. It was giving me an error about not being able to insert a NULL into the server name field, [...]
Simple script to backup all SQL Server databases
March 30th, 2011 Malcolm Chalmers DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName VARCHAR(256) — filename for backup DECLARE @fileDate VARCHAR(20) — used for file name SET @path = ‘C:\Backup\’ SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) DECLARE db_cursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN (‘master’,'model’,'msdb’,'tempdb’) OPEN db_cursor FETCH NEXT FROM [...]
How to list all the databases on a SQL server
March 30th, 2011 Malcolm Chalmers You can list all the databases on a SQL server by running the following query. SQL> select name from sys.sysdatabases
Show Oracle Database DBID
September 29th, 2010 Malcolm Chalmers The database ID or DBID is a unique identification number computed when the database is created. To find out this number, you can either: 1) Login to RMAN, it will display the DBID upon connection to the target database. e.g. shell> rman target / or 2) You can obtain the DBID by querying V$DATABASE eg. [...]
