ORA-03113: end-of-file on communication channel, ORA-07445: exception encountered:
Hi, Startup the database to determine at what phase does this error occur(nomount/ mount/open) IF during nomount -env variables,kernel settings, init.ora NT/2000(corrupted services,registry) If during mount – permissions,env settings,corrupted files/filessystems If during Open -recovery? who generated the trace file, startup trigger problem(_system_trig_enabled=false) corrupted online redo log, datafile (note 28814.1) possible data dict corruption You might [...]

View Answer   |  August 6, 2004  2:28 PM
Oracle

Alternate way to stop Oracle Services on Win 2K Server
I would recommend that you use RMAN to create your backups. You can create a script that the operator can run that will generate hot full, hot incremental or cold backup. This is preferable to stopping the service especially if you are stopping the service through the windows interface. If you stop the service through [...]

View Answer   |  August 2, 2004  6:14 PM
Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, Policies, Security, Servers, Software distribution, Standard Edition, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance

Alternate way to stop Oracle Services on Win 2K Server-2
You could set up a scheduled task to do the backups and use net stop to stop the service and net start to start the service. Set this up in a batch file and schedule it with the credentials of an admin or at least someone who belongs to the ora_dba group

View Answer   |  August 2, 2004  3:04 PM
configuration, Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, patching, PEN testing, Platform Security, Policies, Security, Servers, Software distribution, Standard Edition, vulnerability management, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance

ora-1555 during data purge
Your large rollback segment still isn’t large enough. How often are you doing commits?

View Answer   |  July 20, 2004  10:54 AM
Oracle 8i

Database Replication
First off, I am not an expert on replication. That said, I do know enough to realize that your requirements as rather vague. You want to setup Oracle Advanced Replication, which by all accounts is a formidable task for the uninitiated. Not included are any response time requirements, or descriptions of the network over which [...]

View Answer   |  July 20, 2004  10:02 AM
Architecture/Design, Development, Installation/Upgrade, Oracle, Oracle 8i, Oracle 9i, SQL

RAID configuration for Oracle database
You should be OK on Raid 10. We are currently struggling with a multi-terabyte ERP on Raid 5. Our hardware folks pushed us to Raid 5 so they could celebrate increased performance on backups. As a result we are suffering on all the writes.

View Answer   |  July 19, 2004  12:00 PM
DB2, Oracle 9i, Oracle database design, RAID configuration

Oracle 8.1.7.4 connectivity
Have you checked the listener logs for errors? They should be in <oracle_home>/network/logs. Also, check your alert_log.

View Answer   |  July 19, 2004  4:06 AM
Administration, Installation/Upgrade, Oracle, Performance/Tuning

Error when tried to update the SSOledbGrid connected to with Sybase Server Database
What is the error text? Do you have to use adlockpessimistic or can you use adlockbatchoptimistic or some other type of locking?

View Answer   |  July 16, 2004  3:40 PM
ActiveX, Adaptive Server Enterprise, Database, DB2, Development, Oracle, Servers, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Sybase, Sybase EAServer, Visual Basic

Database Administration
Check your TNSNAMES.ora. What are the settings for your service? should be similar: (this is from my tnsnames.ora. Of course I changes the SID and HOST strings) SIDNAME = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = computername)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sidname) ) ) See what [...]

View Answer   |  July 16, 2004  8:04 AM
Oracle

Data Guard Implementation
We are in the middle of a first production physical standby. I have configured and played with Logical Standby in 9iR2 and 10g. Logical standby first became avail. in 9iR2. With both logical and physical standby the interesting part is how much you want to way down your production server with this. The pivotal point [...]

View Answer   |  July 15, 2004  10:51 AM
Oracle, Oracle 9i

Uninstalling Oracle 9i products from a Window Server
Universal Installer is the best approach.

View Answer   |  June 15, 2004  12:08 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition

Passing array as output parameter through procdure/function
– 1st create a type for the array’s definition – CREATE OR REPLACE TYPE typ_array_text IS VARRAY(500) OF VARCHAR2(4000) / GRANT EXECUTE ON typ_array_text TO PUBLIC / – 2nd declare your functions/procdures to use this type – – NOTE: this function’s inside a package – – the type can now be used anywhere a standard [...]

View Answer   |  June 7, 2004  3:29 AM
Oracle 9i

Connecting to External DB from SAP BW
Hi mpm966, Unfortunately you cannot retrieve lowercase data to BW. You have to create DB views on source DB to convert the data to uppercase. Check SAP note #512739 Hope this helps Thule

View Answer   |  June 6, 2004  6:50 AM
Oracle, SAP

Identifying all SQL generated by a specific session
You can get the information of a specific session from v$session and v$open_cursor views, like in this example: select sid, user_name, sql_text, address from v$open_cursor where sid in ( select v_s.sid from v$session v_s where v_s.program like ‘%LadProc%’) and sql_text like ‘SELECT%’ order by sid,address Here i’m looking for all currently active select statements of [...]

View Answer   |  June 4, 2004  9:27 AM
Oracle

Support of Oracle 8 and 9i
Are speaking in terms of what might be new in Oracle9i, what might have worked in Oracle8 but not in Oracle9?

View Answer   |  June 3, 2004  3:09 PM
Oracle, Oracle 8i, Oracle 9i

ORA-01436 error
Hi, ORA-01436 occurs when a row is an descendant of itself (which is what “loop” means in this context). Usually, this means a mistake in your data. It is possible to have loops in your data, but to do a hierarchical query on a subset of the data, as long as that subset does not [...]

View Answer   |  June 1, 2004  1:11 PM
Oracle 9i

RAC and parallel server
RAC (Real Application Clusters) is the Oracle9i version of Parallel Server. It’s the same principal, but Oracle seems to have gotten its act together a little bit better with RAC.

View Answer   |  May 28, 2004  5:04 PM
Oracle 10g, Oracle 8i, Oracle 9i

Peoplesoft DBA
I was a PeopleSoft DBA from 1/96 – 8/01. It was a great opportunity for me. PeopleSoft made some good strides through the years and seemed to have a stable ERP when my new parent company took us in a very different direction with Lawson software. If the company is small enough to let you [...]

View Answer   |  May 28, 2004  3:00 PM
Oracle

Tools for Oracle database admin, and also Design and Development
Our shop has gone from not being satified with OEM in 7.x and 8.x to very pleased in 9.x. We still have and use the Quest toolset for DB Administration tasks. There are some things each tools does better than the other. If we had to choose at this point, OEM would win since it [...]

View Answer   |  May 27, 2004  2:33 PM
Oracle 9i

Adding column to an exiting primary key
The only way I know of is to drop and re-crwatethe index with the new column names.

View Answer   |  May 26, 2004  4:05 PM
Oracle 9i