Search results for query: *

Hello, I need to ask whether people should run catalog.sql only in maintenance hour. What happened was we had a situation that we can not drop any SQLPLUS users. It generates following errors: ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist ORA-06512...

Hello, I created a web site through IIS with new virtual directory and the port is 8080. When I click the defualt.html from Windows Exporer, it shows the page corretly. However, if I go to the page thru URL, http://server:8080/HR (HR is the virtual directory name) it only displays the source...

Hello, I have test machine upgrated to 9.2.0.6 from 9.2.0.3. Production is still running 9.2.0.3. I need to copy a DB from production to test. Can I just copy all data files over for a new DB (using backup control file script) and then run startup migrate as the instruction of upgrade from...

Hello, We have Oracle 9.2.0.3 installed on the server. I need to install 9.2.0.6 in the same server for new databases. We have /oracle file system for Oracle binary. The current Oracle was installed on /oracle/product/9.2.0 and I am thinking to install new version on /oracle/product/9.2.0.6...

A developer runs this sql and gets 3 rows selected but when I run on my machine I get no row selected. I understand that due to time stamp if use trunc or even to_char (compare charactor) this works all the time. What puzzle me is that with same sql we get different results. I checked her...

Greetings, I created a web site name UPK with local path e:\upk-fs\am and port 8080 (since another web site uses port 80.) However, when accessing with http://localhost:8080/UPK (or http://ipaddress:8080/UPK I got page cannot be displayed. Is this not the right thing to do to create new web...

Hello, We just upgraded HP-UX to 11i. We were using elm to send mail. Can anyone tell me the difference among these commands: elm, sendmail and mailx? What is the standard? Which one has better benefit than others? Thank you very much in advance.

Our Admin is upgrading HP-UX to 11i. He did backup of all files and then install the O/S. He is asking our passwords so he can add them back. I thought you could just restore the /etc/passwd file (maybe change showdow file too?) and use it. But he said that wouldn't work. Can anyone clarify...

We are upgrading our Web server (IIS) from one machine to another. Both are on Window 2000. The new machine has more power. I was hoping the O/S guys can just transfter everything from one machine to the other (including registry for the application - 3rd party web running on IIS). The guys...

I inheret some program and it has a line: . $HOME/.profile noset 2>&1 1>/dev/null Can't seem to find what noset means. Can anyone explain? Thanks in advance.

Hello, How do you schedule a job to run every 1st and 3rd Sunday? With cron, if you use day of the month and day of the week, the two are ORed together. i.e. 00 02 1-7 * 0 /oracle/local/bin/rebuildndx.ksh krntest 00 02 15-21 * 0 /oracle/local/bin/rebuildndx.ksh krntest will run every day of...

Hello, I was trying to clean up oracle trace and log files. We have 10 databases in this HP machine. The directory pattern is /oracle/admin/DBNAME/udump and /oracle/admin/DBNAME/bdump Within /oracle/admin, I did find */bdump/ -mame \* -mtime +90 -print -exec rm -r {} \; find */udump/...

Hello, I have a file which contains something like: STORAGE(INITIAL 50380800 NEXT 8388608 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PS_MEDIUM" ; I need to remove everything starting from STORAGE to ")&quot...

We are using the following scripts (test and test.in) to run some ftp job. User claims the scripts have been working fine until now. I tried to login manually with USER/PASSWD, it login/transfer file successfully. But running this script gets error: 530-331 Password required for (null). 530...

Hello, We are copying files from one machine to another (Oracle and other files). The rcp doesn't seem to copy all soft link files. Is there a way to do so (maybe with a flag)? How about tar? Thanks in advance for your input.

I am planning to automate a procedure to move files from Oracle archive log destination when the file system's filling up. The Unix Administrator told me the move will corrupt file when it's still writing to it. I don't believe this happened when I use Sun box. We are now using HP-UX. Anyone...

Hello, I have a pc at home which I dial up to office to work from home. The password was saved when configured the dial-up property. The network person reset my password but now I can't find how/where to change my password. Went through the property but fail to find where I can change the...

Greetings, I am planning to migrate an Oracle database from DMT to LMT. I need to create a script file from import and then remove all 'STOARGE(...)' clauses from the script. I have over 10,000 objects and manually removing these would be very time comsuming. Is there a way with sed or other...

I thought the following line in the crontab would run only on 3rd Sunday. It turns out to be running Sunday plus every day from 15-22. I am using HP. Is this only for HP or is this generic for all Unix. How would you run a job on 3rd Sunday only? 30 02 15-22 * 0...

I am going to upgrade Oracle to 8.1.7.3 on HP-UX. Can anyone who has done it share your experience? Are there any issues? As I understand, I need to upgrade to 8.1.7 (release 3) first then apply patches to bring up to 8.1.7.3. The zipped patch file for 8.1.7.3 is 278MB size. Seem pretty...