Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: penzk001
  • Content: Threads
  • Order by date
  1. penzk001

    Oracle libraries

    I am installing a new application on a AIX 4.3.3 and Oracle 8i server. The installation is successful, however when i try to load the application the following error crops up. $ . ./setenv $ ./app-start exec(): 0509-036 Cannot load program ecn-admin because of the following errors...
  2. penzk001

    loading data

    People, I am tring to load a table that contains 500000 rows, using the load statement. The syntax I am using is: load from 'movements.unl' insert into movements; The load starts OK, after a while the loading stops saying 271: Could not insert new row into the table. 134: ISAM error...
  3. penzk001

    subg ssh2 with compression

    Hi, I have install open ssh 3.71p1 (zlib 1.1.3.2) on AIX 4.3.3 on five servers. All servers where installed in the same way. However one of the servers, does not allow connections using ssh2 with compression. In the errorlog of the server I am getting the below message: Feb 19 15:27:56...
  4. penzk001

    Trusting

    People, Is there a way to create a trust between two informix servers, without creating the .rhosts in the home directory. In servers involved are 7.30.UC5 (Unix) and 9.30.UC2 (linux). As the security people do not want us to use .rhosts. Thanks Kenneth
  5. penzk001

    rman backups using networker

    Good morning, We have just configured an Oracle 8i (parallel server) to perform open backup using rman. We are using Oracle 8i 8.1.7.0.0, AIX 4.3.3, Legato 6.1.1 Build 238, Module Reports NMO v3.5.0.0. Since the database is still relatively small, we have decided that for two months after the...
  6. penzk001

    sub systems

    How can I determine the command line parameters passed to a sub system? Kenneth
  7. penzk001

    sftp user access

    I have recently installed openssh 3.7p1 on AIX 4.3.3. The installation works fine. I now need to disable sftp to some users, i.e. a user that logs in ssh to the system, he/she can start an sftp session without problems. Is there a file like /etc/ftpusers? Another thing, can the user be chrooted...
  8. penzk001

    Rman backup.

    I have a bit of a problem. We have a production server and we make backups using rman. The database is in archivelog mode. This morning we made the backups (full /control / redo logs). During the day, the client inputed some data. A RAID disk failed and we need to restore the database to log...
  9. penzk001

    ftp daemon

    Good afternoon, I was asked by our security team the port that the ftp daemon ((Version 4.1)uses in passive mode. Is the any document/config file that has these details ? Thanks
  10. penzk001

    Maintenance level

    We have four Bull Escala servers running AIX 4.3.3-10. We are considering to move to AIX 4.3.3-11 (www-opensup.bull.com). Where can I find the procedure to do this (especially where clustering is involved)? Can the maintenance patches be removed if anything goes wrong ?? Thanks Kenneth
  11. penzk001

    Securing on tcpip connections

    Is there a way that I can specify the ip address that can connect to an oracle on AIX 4.3.3.
  12. penzk001

    Update statistics

    Does the database save the timestamp when database statistics were last updated. (update statistics low) Thanks
  13. penzk001

    alert file not being updated

    Good morning, I have encountered quite a strange problem, this morning. The alert file of the machine is not being update, in fact I have restarted the machine (AIX and Oracle 8i) however the alert is still not being updated. Where can i look to solve the problem.
  14. penzk001

    HDR problems

    hi, We are trying to setup HDR (using IDS 7.31UD3X5a) on NCR UNIX. The two enviroments are configured identically. HDR starts successfully (We also created databases and table and everything works fine), when we try to simulate a failure on the primary (onmode -ky), then the secondary is...
  15. penzk001

    Query for administration

    Hi, I need to run a particular query on all the databases of an enviroment. The report must include the database name which I thing I can obtain it from ( set isolation to dirty read; database sysmaster; select name from sysdatabases where name not in ('sysmaster','sysutils');) and to check...
  16. penzk001

    querying several databases using a single cursor

    I would like to run a procuedure to determine the amount to users that have access to some to the production databases. I came up with the following procedure, however I am having troubles when add the query for each user database. DECLARE @db_name varchar(50), @db_users integer, @tab_name...
  17. penzk001

    Tape libraries

    Good morning, I've been tasked to automate the backup of 20 servers (some have SQL server and lotus notes). The solution I have in mind is to have two servers performing backups of 10 servers each using Veritas 9 with the respective agents. (approximate size of each server is 25G) The tape...
  18. penzk001

    automating exp

    I have need to perform automated full dataabse exports, the script works fine however I do not want to put the password in the script. Is there a way I can do that ? I informix, you need to use the OS account informix was installed with.
  19. penzk001

    Ontape backups

    Is there a way to verify an ontape backup without actually restoring it ? Kenneth
  20. penzk001

    spl blocks in informix

    Can anyone tell me convert the following pl/sql block to informix spl. declare db v$database.name%TYPE; begin dbms_output.enable (99999); select name into db from v$database; dbms_output.put_line (db); end; Is there a good pdf for SPL ?

Part and Inventory Search

Back
Top