strange requirement

[prakashs43]

Hi friends ,

i have a strange requirement ..

presently we are running oracle database and some pro*C files oand exe's on vms box

we are planning to move just database to other platform .

can we still use vms oracle libraries for all pro*C programs
but database should connect to remote database ..

problem is we have hardcoded username and password in proC programs but there is no connect string

can we connect to database in different system without connect string.

thanks a ton .

[davey23uk]

i think TWO_TASK might do that for you - not totally sure though

[gandolf989]

Originally posted by davey23uk
i think TWO_TASK might do that for you - not totally sure though

I think you are right.

Oh the evils of hardcoding!

[prakashs43]

Thanks

anything more insight on how to do this TWO_TASK

1) DO I NEED TO CHANGE IN INIT.ORA FILE
2) SHOULD I CHANGE ANYTHING IN LISTENER.ORA IN SERVER AND TNSNAMES.ORA
basically i want to connect from client system without connect string.

[gandolf989]

Originally posted by prakashs43
Thanks

anything more insight on how to do this TWO_TASK

1) DO I NEED TO CHANGE IN INIT.ORA FILE
2) SHOULD I CHANGE ANYTHING IN LISTENER.ORA IN SERVER AND TNSNAMES.ORA
basically i want to connect from client system without connect string.

export TWO_TASK=db_alias_name
export ORACLE_SID=db_alias_name

You will need to point the database in tnsnames.ora to your new machine. You will not need to change listener.ora if you are no longer running a database on the old box. Just migrate the data to the new database and shutdown the old database and listener.

This is basic dba stuff, other than knowing about TWO_TASK there is nothing tricky with this.

[prakashs43]

OK ,


if i have to test this on my windows box how can i do

i tried to add TNS_ADMIN IN environment variables c:/ora9oem/network/admin

then i added in registry hkey_local_machine - software - oracle
LOCAL = TEST.WORLD

TEST.WORLD IS IN unix

still i am not able to connect without connect string

am i missing anything

[prakashs43]

Thanks all you friends ..
setting TWO_TASK worked.

[prakashs43]

This worked in solaris but is not working in open open VMS

in open VM
i am trying

define TWO_TASK "XYZ"

is there anything i am missing
export TWO_TASK=XYY
is working .. do we need to do any additional thing in OPen VMS operating system

[prakashs43]

hi ,

any body has tried doing this ...
appreciate your help regarding this ..

Thanks .

[gandolf989]

Have you looked at help in VMS? I was a computer operator on a Alpha VMS 6.0 cluster over 10 years ago. I was able to learn alot by just typing help at the $ propmt. I actually got my start on VAX/VMS 5.4 running on a cluster with two 11/786's and an 8550. VAX = Medium Iron.