If your WordPress web site has lost connection to its database, you might want to try the steps I’ve linked to below.
you will need the password for the apps account.
To check it is running,
ps -ef | grep FNDLIBR
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
alter database DB1_DEV set SINGLE_USER with rollback immediate
Modify Name = DB1;
alter database DB1 set MULTI_USER
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 ora_dba local group on the server and
- Check that the Log on as a batch job local security privilege has been turned on.
Read More »
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.
To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures.
@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 to use on the link.
The first parameter is the name of the link to use,
The fourth is the account of the remote server to use,
The fifth is the password for the account.