Database Consulting

EXP using 9.2.0.1 client from an 11.2.0.3 database

2 months ago in (0 comments)

When trying to export data from an 11.2.0.3 database using the Oracle 9.2.0.1 client, our dmp files were 12k and the log file was 0 bytes.  The Metalink Note: 550740.1 helped resolve this issue.

1. Connect to the 11.2.0.3 database as SYSDBA through SQL*Plus

2. Change the definition of view EXU9DEFPSWITCHES
From

CREATE OR REPLACE VIEW exu9defpswitches (
compflgs, nlslensem ) AS
SELECT a.value, b.value
FROM sys.v$parameter a, sys.v$parameter b
WHERE a.name = 'plsql_compiler_flags' AND
b.name = 'nls_length_semantics'

To

CREATE OR REPLACE VIEW exu9defpswitches (
compflgs, nlslensem ) AS
SELECT a.value, b.value
FROM sys.v$parameter a, sys.v$parameter b
WHERE a.name = 'plsql_code_type' AND
b.name = 'nls_length_semantics'

3. Re-run the EXP job using the 9.2.0.1 client

Need help? For free development help, leave a comment. Alternatively contact us to see how we can help your organization with Oracle database management and support.

How to duplicate database for standby

5 months ago in , (0 comments)

This is not the first scratchpad sample of duplicating a database for standby you’ve seen, and by no means comes close to the official Oracle documentation.  Its intention is simply for those that don’t use this process often and need a quick reference.

1. You need to startup nomount the standby instance with the bare minimum requirements

DB_NAME=’dbstdby’
DB_UNIQUE_NAME=’dbstdby’
DB_CREATE_FILE_DEST=’C:\Oracle\dbdata\’

2. Connect to rman (in this case with nocatalog)

rman TARGET sys/pwd@db1 AUXILIARY sys/pwd@dbstdby

3. Run your duplicate script (make any other necessary changes for your environment)

RUN {
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER
SPFILE
SET db_unique_name='dbstdby'
set db_file_name_convert='C:\Oracle\dbdata\db1\DATAFILE','C:\Oracle\dbdata\dbstdby\DATAFILE'
set log_file_name_convert='C:\Oracle\dbdata\db1\ONLINELOG','C:\Oracle\dbdata\dbstdby\ONLINELOG'
set control_files='C:\Oracle\dbdata\dbstdby\stby_control01.ctl'; }

Need help?  Free development help, leave a comment or contact us to see how we can help your organization with Oracle database management and support.

Provide Function with Convenience, Reduce Cost

11 months ago in , (1 comment)

Information Technology (IT) is a vital, operational element of most companies. Many companies would not be able to function without the applications and systems on which they rely to deliver their product. However, IT is not where these companies intend to put their primary focus; IT is not how they make their money. Given that thought, companies still spend enormous resources on building and maintaining their IT infrastructure. Often, they have difficulty in controlling their IT expenditures, and look for other ways to handle this vital operation.

By outsourcing their IT operation, companies are free to focus on their core functions, and control their IT expenditures. When outsourcing IT, the systems architecture and the delivery of applications is the responsibility of a service provider. The service provider can deliver IT functions at a significantly reduced cost.

To find out how IT Vizion can help you meet your application needs, please call 1.877.488.4946 or contact us online.

automated statistics gathering

2 years ago in (0 comments)

If you are looking for the GATHER_STATS_JOB in Oracle 11g, then stop looking.  In 11g, this job is part of the daily Oracle Maintenance window, but it is executed as an autotask.  Take a look at this Oracle link.

To check if it exists and enabled, use this simple SQL.

select * from dba_autotask_client where client_name = ‘auto optimizer stats collection’;

Or, to check the log:

select count(*) from dba_scheduler_job_log where additional_info like ‘%GATHER_STATS_PROG%’;

I hope this will save you some [research] time.

SQL Server 2008: 0x84B20001

2 years ago in (0 comments)

On a customer’s production environment, we encountered the following when trying to apply SQL Server 2008 x64 SP1.

“SQL Server Setup has encountered the following error:

A failure was detected for a previous installation, patch, or repair
during configuration for features [SQL_PowerShell_Engine_CNS,]. In
order to apply this patch package (KB968369), you must resolve any
issues with the previous operation that failed. View the summary.txt
log to determine why the previous operation failed.

Error code 0x84B20001.”

Our Fix

Tried a couple of different approaches discussed on the forums, however, the only thing that worked in our situation, was to completely uninstall SQL Server 2008, reboot, then re-install it.  After completing the re-installation, we re-attached the databases and applied SP1 accordingly.

Importance of planning ahead

3 years ago in , , (0 comments)

In this day and age, every business, no matter the size, whether public or private, in one way or another leverages software to cut costs, simplify processes and improve business performance. Because the software becomes an integral part of their business, they cannot afford to have the system down, or not have access to support personnel for these systems.

Too many times we are called upon in desperate times when companies are faced with the fact that they are left with no in-house expertise to support and maintain critical, home-grown software applications. It seems that we can’t get past the idea that people move on. Technical support professionals, programmers, database administrators, software engineers, and other technical folks – will eventually find greener pastures. Are you prepared for that scenario?

Not matter what you heard, and where you heard it, the bottom line on outsourcing or co-sourcing some of your IT functions, such as application maintenance, is that it’s just plain smart. Some companies do it to save costs, some do it because no in-house expertise, some because they want to protect their assets, and some because they want to protect their jobs. Yes. Their jobs. C-level executives don’t typically care for the “why” are we short staffed, but more for the “how” you will overcome the shortage, while still providing a high level of customer satisfaction.

May I suggest you do it for all of the above reasons? Allowing a firm such as IT Vizion, whose focus is on IT, isn’t just cost effective, but a smart approach to protecting your firm’s investments.

We are not an ‘individual’ that will eventually pack up and go. Our customers can count on us to be there for as long as there is a need, and the synergy still exists. We bring top talent to the table, with extensive expertise in all types of Web and Client/Server applications. Our focus is to deliver cost effective solutions that will boost your bottom line. Whether you need someone to maintain existing applications, or are looking to start with a new software that will allow you to automate your business functions, we are capable and ready to take you to that next level.

If all is well now, then this is the time to plan ahead. Don’t wait until you’re left in the dark. Becoming acquainted with software applications doesn’t happen overnight. The company you choose for this task, will need time to learn and understand your systems and your business, before they can be a real asset to you. Spend the time needed to find a long term IT partner that fits your culture, while bringing the complimentary skills needed to support your organization.

IT Vizion is located in Corona (Riverside County, California). We specialize in Java and .NET applications, Oracle and SQL Server databases, while adhering to the highest software development standards. We are proud to promote ourselves as a one-stop IT shop.

View Alex Ivascu's profile on LinkedIn

Go to Top