• Oracle 10g Standard on Win 2003 Server Standard – Shutdown database thereafter cannot Startup, require restart

    Hi there On server side + SQL*Plus tool! connect sys/pwd @sid as sysdba shutdown immediate or abort startup mount ORA-12528: TNS:listener: all appropriate instances are blocking new connection Use lsnrctl status - blockage - stop service + restart same error message. Other steps -->...

    ImraneA0 pointsBadges:
  • Connecting Oracle to Microsoft SQL

    Can anyone assist in connecting my oracle database to a Microsoft SQL server. This will be in the form of table linking. Please this is quit URGENT and your help will be very much appriciated. Thks, anthonio

    2419660 pointsBadges:
  • SQL Server equivalent of Oracle’s desc tablename command

    Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

    Kpatel0 pointsBadges:
  • Oracle 9i Instance and database creation from the command line in WIN NT 2000

    Hi, Has anyone done this using Windows Authentication (the user is an admin and in the ORA_DBA group)? I used oradim to create an instance and did not specify any password. Instance was created but it gave me a TNS-12156 : TNS Protocol Error while connecting "connect /as sysdba". When I specify a...

    Sumeshs0 pointsBadges:
  • Versioning and merging products for oracle

    Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I'm hoping for some recomendations.

    Cleveland0 pointsBadges:
  • Linux based CRM systems

    I know several companies are working on Linux based CRM systems, but are there any commercial grade complete CRM products available on the market today (March 2005)? Thanks

    Japaninsider0 pointsBadges:
  • PMP transitioning from tech oriented projects to business oriented projects

    I am a PMP with 10+ years experience in implementation oriented projects (rollouts, user moves, infrastructure, NetOps, etc.) for internal clients. I want to transition to business oriented projects (SAP, PeopleSoft, SOX, SW development, etc.) for external clients. I am fully familiar with PMI...

    Johnnylac0 pointsBadges:
  • SQL Question

    I am migrating a query from MySQL to Oracle 9i. The query returns the error: ORA-00904: ?Y?.?CATEGORYID?: invalid identifier error message. Which means the column name entered is either missing or invalid. The SQL is below, if anyone can help me resolve this problem, your assistance would be...

    Tlroper0 pointsBadges:
  • SAPDBA not working in ORACLE database

    Dear BASIS Experts, SAPDBA is not working in one of my Server . When I run it gives the error The environment variable NLS_LANG =american_america.we8dec differs form DB value AMERICAN_AMERICA.WE8DEC. Adjust the environment according to DB value !. SAPDBA terminates because data corruption would be...

    PANTSK0 pointsBadges:
  • Problem Migrating from RBO to CBO.

    Hi everyone, I'm trying to migrate from RBO to CBO on an database. The problem I am running into is a little wierd. Some, not all, queries that have a distinct or a subquery in it doesn't return results. How do I get around this and what is happening? Example: SQL> select 2 b.po_id, 3...

    Dansken0 pointsBadges:
  • Database comparison

    I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...

    UselessOne0 pointsBadges:
  • Installation of Oracle9i client

    How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?

    Barusame0 pointsBadges:
  • SYS account problems with 9i

    Hi, When I try to login to the Oracle 9i database as sys, I am getting a TNS-12154 error. Surprisingly, I can log in as SYSTEM and another DBA account. The reason why I need to get in as SYS is to recompile the STANDARD package, as it has become invalid (?), ORA-6553 error and developers are not...

    Sumeshs0 pointsBadges:
  • Slow PL/SQL query

    I'm running the following query against two tables residing on an Oracle 8 database. The query takes too long (over an hour) to run. Both tables are indexed - however the main table SALES.SO is HUGE. Does anyone have any suggestions as to how I could improve this query so it can execute faster....

    Appioriley0 pointsBadges:
  • Domino Database Last Used

    Does anyone have any tools they developed to search all the databases on a server(s) and report on them based on the last modified or created date? Or even point me in the correct direction. I am a rookie. Thanks.

    Coachkaz0 pointsBadges:
  • Lost Passwords in Oracle

    I have joined a company very recently who deploy their product on both Oracle and SQL Server platforms. Theyt seem to have no clue about their dba access passwords for Oracle. How do I get to these passwords? Is there a backdoor or utility which can help me get the passwords on these databases?...

    Sumeshs0 pointsBadges:
  • oracle performance tunning

    Anyone who can share an experince with session_cached_cursosrs: conditions to use, value & desired results - will get a virtual drink. TIA!

    Xlander50 pointsBadges:
  • CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 pointsBadges:
  • Data Architect career path

    I currently work as a data analyst creating reports within an access environment, and in addition have Oracle SQL and Business objects reporting skills. However I am keen to change my career path towards becoming a data architect, and would like to know what training courses to take in order to...

    Guguru0 pointsBadges:
  • Unix ODBC Drivers

    I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on Unix...

    Jk666380 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.