Oracle: Cannot connect

Remember setup
export ORACLE_HOME=/oracle/11g/product/11.2.0

export ORACLE_SID=F87DEV

Install WebCenter 11.1.1.6 on Linux

Prepare linux.

Remember register linux:

yum install glibc.i686

yum install xorg-x11-apps
xhost +localhost.localdomain
    (xhost +computer name)

[reference also: 

other usefull yum(1) commands:

yum provides '*/xclock'

yum grouplist

yum groupinstall 'X Window System'

]

SQL Server: Restore from file

RESTORE DATABASE PSIWebV3
FROM DISK = 'C:\temp\PSIWebV3.dat'
WITH REPLACE

SharePoint 2010: Remove solution wsp from Central Administration

To deploy a solution by using Central Administration


1.On the Central Administration Home page, click System Settings.

2.In the Farm Management section, click Manage farm solutions.

3.On the Solution Management page, click the solution that you want to deploy.

4.On the Solution Properties page, click Deploy Solution.

5.On the Deploy Solution page, in the Deploy When section, select one of the following:

admin.aspx Failed to generate a user instance of SQL server due to failure in retrieving the user's local application data path app_data When move SQL server Express to SQL Server

When moving from SQL Server EXPRESS to SQL Server and then  go to admin.aspx, the error happened:
Failed to generate a user instance of SQL server due to failure in retrieving the user's local application data path app_data

SOLUTION:

• Go to IIS 7.
• Click on the site.
• Double click on Connection Strings. Change the SocalSqlServerr value to new one.

Windows server 2008: the password does not meet the password policy requirements

To disable password policy:
Administrative tools ==> Local Security Policy
==> Account policies ==> Password Policy ==> disable the password complexity check.

Login failed for user 'IIS APPPOOL\ASP.NET v4.0'

Web site connection fail on trying to open a connection to SQL Server.

Add a login to SQL Server for IIS APPPOOL\ASP.NET v4.0 and grant permissions to the database.

In SSMS, under the server, expand Security, then right click Logins and select "New Login...".

In the New Login dialog, enter the app pool as the login name and click "OK".

You can then right click the login for the app pool, select Properties and select "User Mapping". Check the appropriate database, and the appropriate roles. I think you could just select db_datareader anddb_datawriter, but I think you would still need to grant permissions to execute stored procedures if you do that through EF.

From http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0

Oracle: Run Stored procedure with parameter and output

On SQL Developer:

SET serveroutput on;
variable f NUMBER;
execute user.package_name.procedure_name('parameter1', parameter2, :f);
print :f;

Oracle: Run stored procedure

SET serveroutput on;
variable f NUMBER;
execute fasspha.FASSPHA_FINANCIAL_TAG.getEquityRollBack('3140000', 2010, '14.856', '0','PROGRAM','1000126', :f);
print :f;

PwoerShell is not digitally signed. The script will not execute on the system. Please see "get-help about_signing" for more details

In PowerShell, use Set-ExecutionPolicy to change the status

• Restricted – No scripts can be run. Windows PowerShell can be used only in interactive mode.
• AllSigned – Only scripts signed by a trusted publisher can be run.
• RemoteSigned – Downloaded scripts must be signed by a trusted publisher before they can be run.
• Unrestricted – No restrictions; all Windows PowerShell scripts can be run.

Example: Set-ExecutionPolicy RemoteSigned