oracle 9i -> oracle 10g

[timot]

Hi guys, i have questions regarding the oracle. Right now, i have this source code that access to an oracle 9i database, and thinking of migrating to 10g. How do i check whether it's compatible? do i have to check every sql statements and run them one by one (or through a script) or is there a list of differences? where do i start?

and btw, how do i open a .dmp file from oracle? thanks guys!!!!!

 

[sourceninja]

Is this a production application or a personal one?

 

[timot]

production i would say.....

 

[techfuzz]

We just recently upgraded from 9i to 10g. We checked every one of our custom views to make sure there were no performance issues. We found a couple that had to be rewritten. As far as what breaking changes there are going from 9i to 10g, I think you could find that in the documentation. All the documentation is on Oracle's website and is available for download. The query optimizers changed from 9i to 10g, but those have been deprecated--not obsoleted.

Your source code shouldn't be a problem, just replace your Oracle client software with the 10g compatible version and you should be good to go.

techfuzz

 

[sourceninja]

A production app, well then I would setup a 10g server and replicate my database into it for testing. Have the users test the app and see what breaks. The biggest problems we had were tools that were not unicode having trouble with unicode output in 10g.

We run a dev, testing, prod environment. Our dba usually does his homework and knows whats going to break before we even test it.

 

[timot]

that's the problem.... our dba quit, LOL, and i have to do all his work....

 

[sourceninja]

I'd probably hold off then on any migrations until everything was under control.

 

[timot]

humm but now i m responsible for this... =.='"


so, anyone knows how to open .dmp file for oracle??

 

[techfuzz]

dmp files are typically dump files generated when something goes wrong. Typically you use a special utility that comes with Oracle to import them into a special table in the database for evaluation. However, not all dmp files are meant to be imported. It really depends on where it came from and what generated it.

I would strongly suggest you not try to do anything with dmp files until a new DBA has been hired and let them deal with them.

techfuzz

 

[sourceninja]

Oracle is a finicky beast. Its not like mysql where you can go after it with a hammer and it still works. If you do not know oracle, it will kill you and your family. I'd suggest if this is your new job that you convince your company to send you for some training, then start worrying about these tasks.

 

[timot]

hmmm yah ... well basically the source code handles mysql and oracle. And i've calculated the queries that are using oracle..... and it;s a lot.... dang....

and that .dmp file is actually a backup database, how do i open it? and how do i actually create a local database in my machine using 10g? i can modify the source code to connect to my local computer and use the .dmp for the database, but i need some guide. thanks.. lol and yah, this is new to me, but it might be the first move to becoming a dba.. lol gotta learn.

 

[techfuzz]

Restoring a database backup is dependent on the platform. There are utilities built into OEM to assist you in the process. Grab an Into to Oracle DBA book at your local bookstore and start reading. It's not easy so be prepared to spend a lot of time getting up to speed.

techfuzz