Tuesday, June 28, 2011
Oracle SQL Developer to Connect to Sybase
Tried SQL Developer to access a Sybase database for the first time today. All I had to do was go to Tools | Preferences | Third Party JDBC Drivers and add my jTDS driver. After that just configured a connection to use this driver and I was in. This worked fine for qerying data and viewing stored procedures, etc. I was not able to edit the stored procedures with a stored procedure editor.
Sunday, June 19, 2011
Moving Oracle TEMP tablespace
Instead of moving it is much quicker (especially if your TEMP tablespace is large) to create a scratch TEMP tablespace, set the scratch as the default, and then recreate the TEMP tablespace. You will need to drop the original TEMP tablespace, but the creation of the TEMP datafile is instantaneous. once you have the new TEMP tablespace created you can set it back as the default tablespace and then drop your scratch temp tablespace.
Wednesday, June 15, 2011
You can attach just the MDF file in SQL Server to move a database
Moving a database in SQL Server can be done by:
i.e.
exec sp_attach_single_file_db @dbname='MY_DB', @physname='H:\SQL2\MY_DB.mdf'
SQL Server will automatically create a new logfile
- Offlining the database
- Copying the MDF file
- Attaching the datafile at the new server
i.e.
exec sp_attach_single_file_db @dbname='MY_DB', @physname='H:\SQL2\MY_DB.mdf'
SQL Server will automatically create a new logfile
Friday, May 27, 2011
What's going on at Serverside this week [ May 26 ]
- Planning for a EMC to NetApp SAN migration for a large Oracle environment
- Oracle Apex installation along with SSTS System Monitoring application install
- Implementing an ETL process to pull Equity Beta calculations
- Implementing an ETL process to pull used equipment listings and posting results in HTML format
- Troubleshooting performance issues, assisting in disabling high cost jobs that are no longer needed
- Assisting in support of Amazon Store interface
Friday, April 15, 2011
SSRS Browser role assignment
This is one of those tasks that you tend to forget. After you create reports in Microsoft SSRS you need to assign assess to users in your domain. A common way of accomplishing this is to assign these via a Windows domain user or group. Most users will need the Browser role that allows them to view your reports. You can assign this at a folder level or to individual reports. The folder allows permissions to be inherited to all reports under that directory.
To assign the Browser role perform the following procedure below which assumes that your report management url is <your-server>/Reports
I did this via the following procedure
To assign the Browser role perform the following procedure below which assumes that your report management url is <your-server>/Reports
I did this via the following procedure
- Got to http://<your-server>/Reports
- Click on the Properties Tag
- In Security click on the New Role assignment button
- Type in the User or Group name preceeded by the domain (i.e. DOMAIN\username)
- Check the Browser role
- Hit OK
Monday, April 11, 2011
Oracle on Windows - Logon as Batch needed in the Local Security Policy
ok, this one has burned some of my time a couple times now.
When you are configuring Enterprise Manager in a Windows environment you need to modify the Windows Local Security Policy to "Allow Logon as Batch" for whatever user is running the Oracle DB Console service. Otherwise, you will be unable to assign preferred credentials and thus will be unable to create RMAN backups on the server.
When you are configuring Enterprise Manager in a Windows environment you need to modify the Windows Local Security Policy to "Allow Logon as Batch" for whatever user is running the Oracle DB Console service. Otherwise, you will be unable to assign preferred credentials and thus will be unable to create RMAN backups on the server.
Tuesday, March 8, 2011
Oracle on Windows and Password Expiry
If you are running Oracle on Windows and are using a Windows domain account subject to password expiry you need to remember a few follow up tasks after your password has been changed.
- Make sure any Windows scheduled tasks have the new password. You should only need to change one scheduled task and all get the change
- Go into EM/DBConsole preferences and enter the new password for each preferred credential. This includes the Listener, Host, Database Instance, and Agent.
Subscribe to:
Posts (Atom)