Question for Oracle #cr001493

[Kenneth Cheong]

To whom it may concern,

Hey, I am doing a research on web database technologies. In engin
account, I can use "oraperl" to get data from oracle server but I can't
run cgi script. In eecs account, I can run cgi script but I can't run
oracle. Do you have any suggestion what should I do to run cgi to connect
to oracle server? Thanks for your help.

Kenneth

[Woody Kellum]

I assume you are running the CGI script on Solaris. If so, you can
copy the Oracle software from AFS to a machine where the EECS web
server can run the cgi, and also copy perl/oraperl binaries.
There are no licening issues involved. Adapt your script to
see the new ORACLE_HOME, etc and it should work.
- Woody

[Kenneth Cheong]

hey,

I try to copy the oracle software using ftp, and changed to the new
ORACLE_HOME. When I try to run sqlplus, I get a error says " Exec format
error. Wrong Architecture.". What should be the way for copying the
oracle? Can you tell me step by step how can I copy the oracle to my eecs
account?

Thanks,
Kenneth

[Kenneth Cheong]

Hey,

I try to copy oracle to eecs server, but it is not working, when I try to
run sqlplus, i get the message "Exec format error. Wrong Architecture." Is
that mean the oracle cannot run on eecs server, or there's other possible
meaning? How can I fix the problem? Can we meet sometimes so we can
discuss the problem I have? Since it is the project I am working on, it is
very important for me to set up the working environment ASAP so I can
start to write my CGI script. Thanks for your help.

[Woody Kellum]

Sounds like you ftp'ed the Oracle directory in ASCII mode rather than
binary, or you sent it from an HP host rather than a sun.
If the EECS sun has AFS on it, just copy it down from there with
the command:
cd /afs/engin.umich.edu/caen/sun_56
tar cf - oracle-<ver> | (cd <local-oracle-home> ; tar xvf - )

Hope this helps.
- Woody

Does the Sun

In message <Pine.SOL.4.02.990330...@and.engin.umich.edu>, Kenneth Cheong writes:
>hey,
>
>I try to copy the oracle software using ftp, and changed to the new
>ORACLE_HOME. When I try to run sqlplus, I get a error says " Exec format
>error. Wrong Architecture.". What should be the way for copying the
>oracle? Can you tell me step by step how can I copy the oracle to my eecs
>account?
>
>Thanks,

[Kenneth Cheong]

Hey,

I tried it and I still get the message "Exec format error." when I try to
run sqlplus. I don't know how to correct this problem. Another problem is
that when I write my cgi script, it says that "ENV: undefined variable.".
I don't know how to fix this problem too. I think the easiest way for me
to write the cgi is to get the permission to run cgi script on engin
account. If I can get the signature from the professor, can I get the
permission to run cgi script from caen? Can we meet sometimes tommorrow
afternoon or friday? It is very important to me since I have to finish my
project. And there is some problems that is very hard to discuss on the
email. Hope to talk to you soon.

Thanks,
Kenneth

[Woody Kellum]

You can ask about running CGI by sending mail to web-support
The ENV error looks like a perl syntax error, but that is just
a guess.
- Woody

[Kenneth Cheong]

Hey,

The web-support don't let me run CGI on engin. So I think I have to stay
on eecs account to doing it. Can you go to /n/trip/z/kcheong/oracle-8.0.4
to help me to fix the "Exec format error" when I run sqlplus? I set the
permission so you can do anything you want. And can you also go to
/n/www/w/web/u/k/kcheong/public_html to see that when I run "orp.cgi",
why I will get a message "ENV: Undefined variable."? Can you please help
me for this? Since I cannot do anything without setup the environment.

Thanks,
Kenneth

[Woody Kellum]

I need permissions on your personal directory:
cd /n/trip/z/kcheong/oracle-8.0.4
kcheong/oracle-8.0.4: Permission denied
- Woody

[Kenneth Cheong]

Hey,

I changed the permission now, you should be able to go to my personal
directory to modifiy things. Thanks.

Kenneth

[Woody Kellum]

I still don't have access to the files. You need to change the permissions
on the files so that everyone can read/execute them. I don't have an account
on trip, so you can't set the permissions to my id.
- Woody

[Kenneth Cheong]

I try again, it should be working now. So you can go to access the oracle
server and the cgi script now.

Thanks,

[Woody Kellum]

You only changed permissions on the top level. Look at the
man page for chmod, i.e. type
man chmod.
This will tell you how to recursively set the permissions
in a subdirectory.
- Woody

[Kenneth Cheong]

I changed the permissions again using -R. It should be working now.

Thanks,
Kenneth

[Kenneth Cheong]

Can we really meet to talk about it? It is very difficult to communicate
one email per day to solve the problem. And my project is going to due. I
need to solve the problem ASAP.

thanks,