Home » SQL & PL/SQL » Client Tools » Deployment Tools
Deployment Tools [message #331699] Fri, 04 July 2008 12:30 Go to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Hi,
i don`t know if i am posting in the good section for this, but anyone know if any tools exist that can help for database deployment?

I am a developper but also the one responsible for the deployment of fix or bug correction for our application. Actually when i have to install a bug correction in our database, i have to open 10 SQL Plus application and run all script 10 time and recompile all database invalid object for all schema.

Is there any tools that could help me on doing that?
We are actually working with PLSQL Developer too that can help a bit for the recompilation of object and some install script. But what annoy me is having to open my application 10 time to do the installation. I can also open the application only once and change the connection after installing the first account and so on but this is usually taking more time so this is why i am usually opening 10 SQL Plus and i can run all installation at same time.

Is there any solution to this or if i only have to live with that problem?

Thank for your help.
Re: Deployment Tools [message #331700 is a reply to message #331699] Fri, 04 July 2008 13:03 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can put all the commands you need run in ONE SQL script, and then run just that one script in SQL*Plus do do your deployment.

You can connect to different databases in that script, or call as many other scripts as you like from it.

And then you can call one procedure to compile all invalid schema objects at the end. For example by using the procedures in the UTL_RECOMP package.

There no need that I can imagine that would require to open multiple SQLPLus applications to do it.
Re: Deployment Tools [message #331701 is a reply to message #331699] Fri, 04 July 2008 13:12 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/

OS name & version?
Oracle version to 4 decimal places?
Re: Deployment Tools [message #331702 is a reply to message #331699] Fri, 04 July 2008 13:17 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Oups!
sorry about missing information.

Database is on Windows Server 2003 SP2
and DB version is 10.2.0.4.0

[Updated on: Fri, 04 July 2008 13:17]

Report message to a moderator

Re: Deployment Tools [message #331703 is a reply to message #331701] Fri, 04 July 2008 13:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
anacedent wrote on Fri, 04 July 2008 20:12
Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/

OS name & version?
Oracle version to 4 decimal places?

Very curious what solution you have in mind that it would depend on that info, especially the database version in 4 decimals specific..
Re: Deployment Tools [message #331705 is a reply to message #331699] Fri, 04 July 2008 13:25 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
I know it is possible to do it all in 1 script but i don`t want to hardcode in the script username and password of production database for security reason.

My question was more to know if there is any tool that can help during deployment of database object

Thank
Re: Deployment Tools [message #331706 is a reply to message #331705] Fri, 04 July 2008 13:35 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
SQL*Plus IS the best tool available. Smile

If you don't want to hardcode usernames and passwords you can use substitution variables, and ask for them at the start of the script with PROMPT / ACCEPT.

Have a look a the FAQ here for some pointers.
Re: Deployment Tools [message #331707 is a reply to message #331699] Fri, 04 July 2008 13:42 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
You're right about substitution variable.

I will see if i can build some kind of template script for my installation since i don`t want to write the script for all installation.

You also confirmed me what i was thinking about SQL Plus being the best tool to do this

Thank for your help.
Re: Deployment Tools [message #331708 is a reply to message #331699] Fri, 04 July 2008 14:27 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>especially the database version in 4 decimals specific
I was asking so Michel would get his desired response.
Previous Topic: Need SQL Query
Next Topic: Unable to Connect
Goto Forum:
  


Current Time: Fri Dec 02 14:30:20 CST 2016

Total time taken to generate the page: 0.09717 seconds