Browse by Tags

  • Install Oracle Client

    The dbas asked me to install Oracle client on the new box by copying the contents of the Product and oraInventroy folder from a server installed with oracle client and modify the .profile of oracle user after adding oracle user to the server. Now, i am unable to start sqlplus. What do i have to do to...
    Posted to 10.x (Forum) by software on 02-11-2010
  • Corrupt block relative dba: 0x0280005a

    Hi, One of my dbf file is corrupted (Please see the attachment). So i have used below query to find the corrupted tables/indexes. select owner, segment_name, segment_type from dba_extents where file_id = 10 and 90 between block_id and block_id + blocks - 1; This query output is no records. After that...
    Posted to 9.x (Forum) by software on 01-29-2010
  • Updating SQL Table Field to "Blank"

    We have an Oracle database. We need to have one table (F0092  table owner SY811) updated. we need to have the field: ULUGRP updated to blank. In a database called: USSPD just wanted to confirm what the SQL command would be to perform this update? Thanks
    Posted to Oracle (Forum) by software on 01-26-2010
  • Connection to x as user y failed: ERROR: Wrong password for user

    Running Oracle 10.2.0.3 on Windows 2003. Receiving the following error: Connection to x as user y failed: ERROR: Wrong password for user. I know the password is correct and the LOGON AS A BATCH JOB privilege to the OS User has been set. Any ideas why I'm still getting the error?
    Posted to 10.x (Forum) by software on 12-05-2009
  • Automatically update Org Chart when DB is updated

    I'm using Visio 2007 to creage an organization chart. I have successfully syncronized it with the heirchal employee structure in our ERP system which uses an Oracle 9i DB. I was pleasantly surprised by the results. I was also able to save it as an html file and post it on our Intranet site. However...
    Posted to Visio (Forum) by software on 12-01-2009
  • BACK UP Software and Disaster Recovery Planning

    I have windows 2003 active directory envoirnment,I have windows 2003 servers,Oracle Data base,SQL Data base,Microsoft exchange 2007. Can you please suggest me the good back up software which provides disaster recovery and can back opne files ? Thanks and Regards
    Posted to Disaster Recovery (Forum) by software on 11-28-2009
  • How to recover Oracle database, getting ORA-01122, ORA-01110, ORA-01207

    Here is how the problem began, when starting up the database we got the following error message: ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/u12/oradata/evolmo/system01.dbf' ORA-01207: file is more recent than controlfile - old controlfile I have re-created...
    Posted to Oracle (Forum) by software on 09-23-2009
  • Setting session parameters under logon trigger

    Creating trigger below does not update session parameters NLS_COMP and NLS_SORT. SELECT * FROM NLS_SESSION_PARAMETERS WHERE PARAMETER='NLS_COMP' OR PARAMETER='NLS_SORT'; output: ---------------------------------------- NLS_SORT SLOVENIAN NLS_COMP BINARY Trigger is executed.(I've inserted...
    Posted to Oracle (Forum) by software on 08-23-2009
  • Need to move Oracle 9i Database from One Machne to another

    I need to move an Oracle 9i database from one machine to another. The directory structure is NOT the same between the two machines. They are both running Sun Solaris, but the database is currently on OS 9 and the new machine is OS 10. The database is between 5 and 6 GB.
    Posted to Oracle (Forum) by software on 08-10-2009
  • OEM Error for the SQL Server Configuration

    Hi All, I have the SQL Server Plugin Configured for the OEM Agent. I have added a SQL Server database and was working fine. There are 2 SQL Server databases which needs to be configured under the same agent. I was able to add them with various SQL Server Ports. The Server Connection test ran successfully...
    Posted to 10.x (Forum) by software on 08-10-2009
Page 1 of 7 (63 items) 1 2 3 4 5 Next > ... Last ยป