Search results for query: *

Hi, Solaris 8 & 9 on SUN v250 and v240's. Quantum DLT7000, desktop enclosure version, not rack mountable. Is there a limit to how many DTL7000's can be placed on the same SCSI bus? I'm using the internal SCSI connection that came on the servers. When I connect two together (using different SCSI...

Hi youradds , I believe obadare meant to use scp instead of ssh : scp -r username@server1:[directory_to_copy] username@server2:/destination_directory Good Luck DrD

Hi nimrodman, Cygwin/X would be the way to go. http://x.cygwin.com/ It's lightweight, FREE, easy to use and non intrusive on the Win OS. Plus it gives you a ton of *nix/GNU tools and programs to work with in your Win environment, if you so choose. Good Luck DrD

Hi stfaprc, The changes to /etc/hosts, /etc/hosts.allow, /etc/hosts.deny or /etc/hosts.equiv... don't require a restart of any daemon or service. Let us know if this solution works for you. Good Luck DrD

Hi Fred, Is the system a laptop or desktop? If a desktop, the easiest, safest and most reliable way to do it...> Get a 2nd HD, unplus the Vista HD for a bit while you install the whole Linux OS to that, instead of messing with boot sectors, shrinking partitions, etc... that way if you ever...

Hi stfaprc, There is also the option of hosts.deny and hosts.allow files. An example in the file would be: ALL : 220.248. ALL : 60.12. This would block/refuse connection from all IP's in the 220.248.x.x and 60.12.x.x IP blocks. Or you can use: ALL : ALL Then use the hosts.allow file to...

Hi cleanair4me, Mufasa has the right answer from the Oracle perspective. Another place to look since it is a web app connecting would be the webserver logs. Which also include any failed attempts, which good to know from a security stand point. Not sure of the webserver in use, so I can't...

Hi Gatec, I see you're on a *nix based system. Do you have access to the system logs? Or can someone copy the contents of them and sends them to you? They'll be in /var/adm or /var/adm/syslog, or var/log. The files could be messages, syslog.log, some iteration of local#.log, etc... What you...

Hi, Just to add a little more info if I could. A good practice for dB's these days (heavy I/O ones, not necessarily data warehouse, although it can apply)is the SAME method (Stripe All Mirror Everything). A lot of times it's not the amount of space you have available, but the spindles to...

Hi, Thanx for the responses. By binary files I mean.. not text files. I'll have a look and see if the "RECSIZE+BUFFERS parameter and POSITION() " can work for us. Another thing with this is these files would just be queried in the external table, and not loaded into the dB. So using SQLLDR...

Hey Dave, thanx for the info... I did a web search as well and couldn't find what's needed. I'll login to metalink and have a look and let everyone know the outcome in the end. Thanx drd

Hi, A quick question on External tables, if I could I'm aware of how to use them with text/CSV/flat files... Can binary files be used at all? Or possibly with coding done in ProC so it can know the structure of the binary file? Thanx DrD123

Hi gatec, yes it looks like stefanhei solution is the only way to remove it completely. as opposed to it just not being used 1st, export all data, via exp (since this is 9i?), from the tables residing in the offending table space. Then drop that table space. Then recreate it with the...

I hit the submit button too quick while adding the CODE box... If NOT in NOARCHIVE mode use this: ALTER DATABASE '/dev/rdevl_0064_04' OFFLINE DROP; COMMIT; Good Luck DrD

Hi gatec, Is the dB in NOARCHIVE mode? If so, this will take care of it: ALTER DATABASE DATAFILE '/dev/rdevl_0064_04' OFFLINE DROP; COMMIT; Let us know how it worked out for you. Good Luck DrD

Hi Goodman, Taking T's suggestion a little further, use on the tables: "dbms_stats.gather_index_stats" & "dbms_stats.gather_table_stats" and/or use, on the whole schema: "dbms_stats.gather_schema_stats" Good Luck DrD

Hi Exie, Do you still have access to your Oracle 9i installation on the current server? The most efficient way ( and the most recommended on this board) is to do a full export of your data (not system files though) on the Oracle 9, then an import into Oracle 10 system. If you try bringing...

Hi Ed, You can raise the ulimit for your current dB export by: ulimit -f unlimited ulimit -d whatever_size_in_kb_it_needs_to_be For global changes, you'll need sysadmin privileges Good Luck DrD

Hi Ed, On the AIX server from the same terminal you're trying the export from, can you run the following commands and post your results?: ulimit -a What you may need to do for the export sessions, is make your ulimit unlimited for filesize. Good Luck DrD

Hi ranjan, Usually CRON's run SH and not BASH. But try this: In your CRON entry you just source the file with the variable(s) that'll be used: 00 10 * * * . /PATH_TO/.SOUCE_FILE; /export/home/YOU/cron/bin/SCRIPT > /export/home/YOU/cron/log/SCRIPT.log 2>&1 & Good Luck DrD