Posts

Power Shell Script to Schedule a Event Log Notification Through Email

-
Step 1 :      Copy below scripts and paste it in notepad and modified the script. $HostName = (Get-Wmiobject win32_computersystem).__server $File1 = "C:\$HostName-System-Error.htm" $File2 = "C:\$HostName-System-Warning.htm" $File3 = "C:\$HostName-Application-Error.htm" $File4 = "C:\$HostName-Application-Warning.htm" Get-EventLog -LogName "system" -EntryType "error" -After (Get-Date).AddHours(-24) | ConvertTo-HTML | Out-File $File1 Get-EventLog -LogName "system" -EntryType "warning" -After (Get-Date).AddHours(-24) | ConvertTo-HTML | Out-File $File2 Get-EventLog -LogName "application" -EntryType "error" -After (Get-Date).AddHours(-24) | ConvertTo-HTML | Out-File $File3 Get-EventLog -LogName "application" -EntryType "warning" -After (Get-Date).AddHours(-24) | ConvertTo-HTML | Out-File $File4 Send-MailMessage -Attachments $File1,$File2,$File3,$File4 -SmtpServer " you...
Read more

MySQL Dump version mismatch error while taking MySQL Dump form MySQL Server.

-
Image
 While exporting a database hosted on MySQL Server 5.6.10 using MySQL Workbench 5.2.47 we will get an  Version  mismatch error in MySQL work bench. Solution: Copy the mysqldump.exe (version 5.6.10) from the MySQL Server 5.6 installation folder( C:\Program Files\MySQL\MyS QL Server 5.6\bin\Mysqldu mp.exe)  and replaced the mysqldump.exe (version 5.5.16) at the MySQL Workbench 5.2 CE folder( C:\Program Files (x86)\MySQL\MyS QL Workbench CE 5.2.47\MysqlDum p.exe) . 
Read more

Copy or Move Database from Instance to Another Instance:

-
Image
Copy or Move Database from Instance to Another Instance: 1) Connect both SQL servers source and destination instance into SQL server Management studio. 2) Specify source server and use sql server authentication and give credentials. 3) Specify destination server instance and sql server credentials. 4) S elect option that want to keep the database ONLINE when it is being copied. 5) Here you can select move or copy database. 6) Give database Name. 7)  select additional options to copy as well. 8) Click Next. 9)  Click Next or  schedule the package using SQL Server Agent. 10) Click Next When this process is over it will show the success message and database will be copied to another server. Note:  1) SQL server  agent services must be started  in both instance configuration manager. 2) Both SQL server agent must running on same user name and password(current system user name and password)
Read more

Install OBIEE 11g on Windows by using Microsoft sql server as an database server

-
Image
Download  Oracle OBIEE 11G  on your PC as per system architecture. http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html And download RCU( Repository Creation Utility  ) from same page where u downloaded OBIEE. Extract RCU and open rcuHome\BIN location Run RCU bat file and click next. Select create repository option and click next. Select database type as microsft sql server. Unicode support: Yes Server Name: complete server name or ip address or host\server format. Port: 1433 Database Name: Open SQL server management studio. create one new database in sql server(Ex OBIEE) and whle creating database In sql server in owner option give admin user name(ex: sa) and click apply. And open Quiery window. Execute below commands.   ALTER DATABASE obirep COLLATE Latin1_General_CS_AS ALTER DATABASE obirep SET READ_COMMITTED_SNAPSHOT ON Navigate in to rcu_home folder rcuHome\rcu\integration\epm\registry\scripts\sqlserver and open createfr.sql into n...
Read more