Search results for query: *

Thanks to all for your answers. SOL I'm only guessing but my guess work generally works for me.

Hi, I'm struggling with dates in vb6. I'm trying to take todays date and output in the format 'ddmmyy'. I thought this would be relatively easy and currently have the code below. Dim today As Date today = Format(Date, "ddmmyy") MsgBox today The output is 04/07/2751, so obviously I'm missing...

Hi this is resolved SOL I'm only guessing but my guess work generally works for me.

We are also receiving the following message which may be important. "Serial console port error has occurred. A single character may have been lost. Console port recovered" SOL I'm only guessing but my guess work generally works for me.

Hi, I have an issue on a hp-ux 11 server. One of the IT staff changed the netconf file and on reboot the server is generating a "init command respawning to rapidly" statement and will not boot up. I have been trying to get the server to boot up into single user mode from the Web Console. After...

Top is showing no activity for any of the Oracle processes, so I'm not particularly hopeful. It's looking like a bad day. SOL I'm only guessing but my guess work generally works for me.

Thanks, SantaMafusa. That rings a bell, I think I've seen a database do that as well a long time ago. The database has been left trying to open for about 20 minutes, however given the work involved if we have to do a tape restore then it's probably worth leaving it a while longer. SOL I'm...

Hi engineer2100. This has been tried, bringing it up and down to various states. The problem is it never gets to the open state. Regards Sol SOL I'm only guessing but my guess work generally works for me.

No, it just hangs, presumabley trying to open and getting nowhere! SOL I'm only guessing but my guess work generally works for me.

Hi, It hangs so it isn't possible to issue an open statement. I can't see anything in the alert log, but then I'm not an expert at interpreting them. Here are the last few lines, is that helps at all. Regards SOL Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Mon Jul 2...

Hi, We recently lost power unexpectedly to our server. Now when we try and start it we receive the following. > SQL> startup > ORACLE instance started. > Total System Global Area 110033940 bytes > Fixed Size 76820 bytes > Variable Size 76230656 bytes > Database...

I have a server with three small volume groups and the IT manager of the site has bought a giant disk which he wanted to mirro the three volume groups to. I guess he can't do this then? SOL I'm only guessing but my guess work generally works for me.

Thanks for that. Sorry I did mean volume groups. You say you can put one disk in exactly one volume group. Does that mean I can't put more than one volume group on a one disk? SOL I'm only guessing but my guess work generally works for me.

Hi, I'm planning a disk mirror strategy on HP-UX 11. Is it correct that you can only define one volume per physical disk using LVM? Thanks SOL I'm only guessing but my guess work generally works for me.

Hi, Thanks for the reply. For one of the tables I have the following differences in dba_tables Initial Extent 17547264 59064320 Next Extent 29458432 44187648 Blocks 6404...

Hi, I have a live tablespace that once exported from the database and imported into a test database is about 50% larger than the original tablespace. Can anyone help me to understand what could be causing this phenomenon please? Regards SOL I'm only guessing but my guess work generally works...

Thanks for the tip, I did yes. SOL I'm only guessing but my guess work generally works for me.

Hi, I have an Oracle 8.1.7 instance on a HP-ux server. I have had to restore the entire instance to another server in order to recover a table. However I cannot get the instance to start up on the new server. I have managed to start the listener however when trying a "startup nomount" in svrmgrl...

Thanks for that Ken, there is a lot of good information in there that has sparked off some ideas I can try. SOL I'm only guessing but my guess work generally works for me.

Thanks for the well wishes Ken, unfortunately due to cheapskate managers and restricted disk space the server is running in NOARCHIVELOG mode which means that last night is about the best I can hope for I think. SOL I'm only guessing but my guess work generally works for me.