I am building a backup IBMR2 server with AIX 4.3 operating system. The application uses a TUXEDO front end. I am getting an authorization error when I try to bring the system up with tpchkauth error. I need to know how to find the value of this field so I can compare it to my production server. Is there a simple way to do this? Am I going about this the wrong way? I know next to nothing about UNIX and AIX.
I have no idea what a "IBM R2"(?) server is. You mean IBM R/6000?
"tpchkauth" is an Oracle function and has nothing to do with the OS, so perhaps best to consult some database administrator.
Running AIX 4.3 (which is out of service now for some 10 years) on a productive environment is a very, very, big risk. You should plan for an update.
I hope this helps.
bakunin
/PS: could it be that you have to install the password for the database encryption into the wallet of your backup server?
Yes i am running on a IBM R6000. Database is Oracle 7.3.3 (nightmares). we will be installing a new system next year but it will take about 18 months. in the mean time i have to keep this sytem up on a refurbished machine installed in 2005. where would i find the "wallet". thanks much for the info.
I sympathize with you.
I have no idea. I only know that it exists in oracle databases (not even sure in yours) because i overheard DBAs cursing the damn thing in a project some time ago. When one deals with encrypted tables there has to be the "password" stored somewhere so that the entitled procedures can decipher the data as they are retrieving it. This file is called a "wallet" in Oracle vocabulary and this is about as much as i know about it. As i am not a DBA my hint is only of limited value, but maybe you can find a DBA to help you analyze your problem.
I hope this helps.
bakunin