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
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
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
Your large rollback segment still isn’t large enough. How often are you doing commits?
View Answer | July 20, 2004 10:54 AM
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
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
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
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
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
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
Universal Installer is the best approach.
View Answer | June 15, 2004 12:08 PM
Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Standard Edition
– 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
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
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
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
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
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
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
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
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