f



oracle 9i (9.2.0.1.0) - sql analyze login error

Hi!

I have a standalone oracle 9.2.0.1.0 database. Then I start sql analyze in
oracle enterprise manager console.
In the login box I select 'standalone repository'.
User: sys,  Password: is okay, Service: is okay.

I get the following :

ORA-28009: connection to sys should be as sysdba or sysoper.

Who can help me?

Thanks!


0
huma1 (15)
2/27/2004 10:35:05 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

2 Replies
699 Views

Similar Articles

[PageSpeed] 43

"Hubert Mayr" <huma1@gmx.net> a �crit dans le message de news:1077876364.992762@news.liwest.at...
> Hi!
>
> I have a standalone oracle 9.2.0.1.0 database. Then I start sql analyze in
> oracle enterprise manager console.
> In the login box I select 'standalone repository'.
> User: sys,  Password: is okay, Service: is okay.
>
> I get the following :
>
> ORA-28009: connection to sys should be as sysdba or sysoper.
>
> Who can help me?
>
> Thanks!
>
>

ORA-28009 connection to sys should be as sysdba or sysoper
Cause: Connect sys/password is no longer a valid syntax.
Action: Try connect sys/password as sysdba or connect sys/password as sysoper.

Starting with 9.0, sys cannot connect anymore as a normal user,
it can only connect as sysdba or sysoper.

Regards
Michel Cadot


0
Michel
2/27/2004 2:30:02 PM
Hi,
set O7_DICTIONARY_ACCESSIBILITY =TRUE.
regards
Srivenu
0
srivenu (188)
3/1/2004 7:46:36 AM
Reply:

Similar Artilces:

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versions are different. I am getting error on my client mechine, it showing all memory address on the screen and the part of error is, arg register addr=83498cc .... Dump of memory from 0x83988c to 0x83499cc .... -- End of Call stack trace -- I am not able to trace where the problem is.Any insight please... Thanks, Ssreddy. ...

oracle 9i (9.2.0.1.0)
Hi! when I call the oracle performance manager I get the following errors: VTM-0002: error when displaying graph java.lang.null.pointerexception at oracle.sysman.vtd.VtdCartridge.lookupClass(VtdCartridge.java:1313) ..... what is my problem? Thanks! ...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy the Oracle CD to the hard drive. I copied it to a subfolder directly to C:\Oracle9i 2. Change the file c:\oracle9i\install\ORAPARAM.INI to reflect the actual name of the directories listed in the install directories of the cd I just copied. I did this and next took out some "."s and put the absolute path to the java program and something called the "OUI_LOCATION". JRE_LOCATION=C:/oracle9i/stage/Components/oracleswdjre/13110a/1/DataFiles/Expanded OUI_LOCATION=C:/oracle9i/stage/Components/oracleswdoui/220120/1/DataFiles/Expanded Okay so good so far. This time the installer actually started. The problem occurs in the next few steps, when I click "next" (weiter in German) from the welcome screen- please understand if I translate something wrong here. Then I am shown the installation directory screen, where I select the default listed: Source : C:\Oracle...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, > > does anyone can provide the node document information of step by step > doing it. > > many thanks > > leehi Go to metalink.oracle.com (registration and Oracle support CSI required). Click on Patches and Updates tab. Wait for the whole screen to load. Use one of the search functions to find your patch (note the Quick Links if you are getting something common, like 9206 or 9207). When you finally get to your patch download, click on the readme (the piece-of-paper icon next to the download icon). Read all the instructions. It's a good idea to read the instructions every time you do it, even (or perhaps especially) when you are comfortable doing it. The readme is usually also included with the patch. Download and unzip the patch. Look at what is there in the patch, perhaps there are additional release notes. Look around on metalink for addition...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard disclaimer: http://www.dbainfopower.com/dbaip_advice_disclaimer.html "kumu" <forlist2001@yahoo.com> wrote in message news:a44abd39.0402161837.6badb9ed@posting.google.com... > Hello All, > I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or > 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? > > Also I had a bad experience with my development server when applying > 9.2.0.3 patchset. Is there anything you recommend before I start > again? > > Thanks > Kumu "Ron" <support@dbainfopower.com> wrote in message news:<QqWdnRM_cMiwWqzdRVn-vg@comcast.com>... > Hello Kumu, > > What is the reason for upgrade? Any specific bugs or issues you > experience? > > You can open TAR as well to get support recommendations for your > situation. > > New patches can introduce new...

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
The performance of some complex PL/SQL functions has dropped dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out, that Oracle 9i performance on a multi processor CPU machine (our server has 4 XEON CPUs, Hyperthreading is disabled in BIOS) is highly dependent on init.ora parameters; unfortunately our trial and error approach to find the proper settings (we searched Oracle Tech Net (OTN) and google groups without success) did not help so far. We are testing performance behaviour with some business critical PL/SQL procedures that do authorization calculations for our application. Simplified these functions do a lot of inserts, deletes and selects in/from tables (being used as temp tables in lack of in memory temp table support of oracle 9i). We can monitor the progress within the stored procedure by using UTL_FILE functions to write a log file into the file system of the server; we real time monitor the log file using "tail -f". <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); [...] When setting "CPU_COUNT = 1" in init.ora the function will typically run up to 10 seconds, when setting "CPU_COUNT = 4" it will take more than 2 minutes (!!!) We experimented with the following other parameters so far: db_writer_processes (set to 4 in combination with cpu_count = 4) fast_start_parall...

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.com> schreef in bericht . > How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 > > 1-what scripts are to be used > 2-Where i can find these scripts. > > Thnks. Hi, I guess oracle dosen't support backword comatibilty.then how it is possible?? Thanks Alok. On 9 Aug 2005 22:05:49 -0700, alok.behria@gmail.com wrote: >Hi, > > I guess oracle dosen't support backword comatibilty.then how it is >possible?? > >Thanks >Alok. Oracle is backwards compatible provided you have the definition of backwards compatible correct. You can connect (again) *lower version client* to a *higher version database* The other way around has nothing to do with backwards compatible, though it usually works, *with the exception of export/import, AS DOCUMENTED* (but I guess no one ever reads the docs) -- Sybrand Bakker, Senior Oracle DBA Hi, ...

Oracle 9i (9.2.0.1.0) Install link errors
Greetings: I'm trying to install Oracle 9i Enterprise Server and Client on a 64 bit Solaris 8 machine. I encountering link errors as follows: Calling action unixActions2.2.0.6.0 make installMakePath = /usr/ccs/bin/make installMakeFileName = /opt/oracle/product/9.2.0.1.0/network/lib/ins_net_client.mk installTarget = ntcontab.o installArguments = ORACLE_HOME=/opt/oracle/product/9.2.0.1.0, undoMakeFileName = null undoTarget = null undoArguments = null logFile = /opt/oracle/product/9.2.0.1.0/install/make.log Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target ntcontab.o of makefile /opt/oracle/pr oduct/9.2.0.1.0/network/lib/ins_net_client.mk Exception Severity: 1 This was while the OUI was trying to execute the following make command: /usr/ccs/bin/make -f ins_net_client.mk ntcontab.o ORACLE_HOME=/opt/oracle/product/9.2.0.1.0 I can actucally manully execute this on the command line and it seems to work but I'm sure not properly since I'm sure there are some paths that it needs which would have normaly been set in the install script. I believe I have something not set properly prior to starting the Oracle Universal Installer but I'm not sure what (i.e., environment variable, or compiler option). Any advice would be appreciated. Cheers! On Thu, 04 Dec 2003 18:59:29 GMT, "Joseph Dimech" <joe@tsc-corp.com> wrote: &...

problem with dbca on Oracle 9i R2 9.2.0.1.0 Linux
When I want to start dbca on my installation I get Java errors below: System is a RH 2.1 AS. $ dbca Exception in thread "main" java.lang.NullPointerException at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1897) at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1962) at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1954) at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1946) at oracle.sysman.assistants.util.NetworkUtils.getOneLocalListenerProtocolAddress(NetworkUtils.java:1863) at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddress(NetworkUtils.java:736) at oracle.sysman.assistants.util.NetworkUtils.getLocalListenerAddresses(NetworkUtils.java:774) at oracle.sysman.assistants.util.NetworkUtils.needLocalListener(NetworkUtils.java:712) at oracle.sysman.assistants.util.step.StepContext.setListenersToUpdate(StepContext.java:485) at oracle.sysman.assistants.util.step.StepContext.<init>(StepContext.java:139) at oracle.sysman.assistants.dbca.backend.Host.<init>(Host.java:454) at oracle.sysman.assistants.dbca.ui.UIHost.<init>(UIHost.java:185) at oracle.sysman.assistants.dbca.ui.InteractiveHost.<init>(InteractiveHost....

Error applying patch p3948480_9206 to Oracle 9.2.0.1.0 on Tru64
Hi all, I'm trying to apply Patch p3948480_9206 to Oracle 9.2.0.1.0 on Tru64 Alphaserver 5.1A. I have all the System Requirements (like Tru64 UNIX version 5.1A Patches). I stop the listener and dismount the database, but when I start the Installer of the patch p3948480_9206 appears this error: Checking swap space: 10 MB available, 150 MB required. Failed<< I have two swap partitions: The first one of 1GB and the second of 1.96GB.Total swap space is about 2.96GB and the available space is 97% !!!! How can I solve?? Thanks Have you had a previous failed installation... Oracle sometimes doesn't clear up used memory after a failed install which can cause problems like this. Are you able to reboot the server and try again..? Also run "ps -fu oracle" to see what other oracle processes are running. Matt ...

upgrate from 9.2.0.1.0 to 9.2.0.7.0
how to upgrade.... storm pixie wrote: > how to upgrade.... You grab the upgrade download and install it. Or you re-install from a complete base version. No rocket science, just follow the instructions. On 17 May 2006 17:55:59 -0700, "storm pixie" <amit.dba@gmail.com> wrote: >how to upgrade.... go to metalink download patch. find readme.html in the patch dowloaded follow test on non-production system first when it doubt, re-read the readme. ........ We run Oracle 9iR2,10gR1/2 on RH4/RH3 remove NSPAM to email Download patch or request a cd from oracle supp check the current installation. follow the instruction as the readme file. install the latest jvm patches for OEM. Please take note Oracle Workspace is only 9.2.0.5. You can always log a tar in metalink for support Download patch or request a cd from oracle supp check the current installation. follow the instruction as the readme file. install the latest jvm patches for OEM. Please take note Oracle Workspace is only 9.2.0.5. You can always log a tar in metalink for support ...

Bind Errors
Recently migrated from 8.1.7 to 9i and my Oracle Reports are no longer working -- I am getting an ORA-01006 Bind Variable does not exist. Has anybody had any success running reports developed in 2.5 to run against 9.2.0.6.0? They are working on 9.2.0.1.0 but I am rushed for time - don't really have the resources to upgrade this and all the instances on it so quickly. ManChild wrote: > Recently migrated from 8.1.7 to 9i and my Oracle Reports are no longer > working -- I am getting an ORA-01006 Bind Variable does not exist. Has > anybody had any success running reports developed in 2.5 to run against > 9.2.0.6.0? They are working on 9.2.0.1.0 but I am rushed for time - > don't really have the resources to upgrade this and all the instances > on it so quickly. Apparently the concept of testing evaded your management. Did you check metalink? -- Daniel Morgan Puget Sound Oracle Users Group On 12 Sep 2006 14:48:48 -0700, "ManChild" <starritt@gmail.com> wrote: > >Recently migrated from 8.1.7 to 9i and my Oracle Reports are no longer >working -- I am getting an ORA-01006 Bind Variable does not exist. Has >anybody had any success running reports developed in 2.5 to run against >9.2.0.6.0? They are working on 9.2.0.1.0 but I am rushed for time - >don't really have the resources to upgrade this and all the instances >on it so quickly. Please answer the question when Reports 2....

update Oracle from 10.2.0.2.0 to 10.2.0.2.0
Where can I get the software for 10g 10.2.0.2.0. for Windows XP 32 bit. Thank you very much. "keekee" <moongeegee@gmail.com> a �crit dans le message de news: f3b21ed0-12fd-4812-b9da-60cf59d508b9@i9g2000yqi.googlegroups.com... | Where can I get the software for 10g 10.2.0.2.0. for Windows XP 32 | bit. | Thank you very much. On Metalink (My Oracle Support). https://support.oracle.com/CSP/ui/flash.html Regards Michel ...

oracle 9.2.0.1.0 questions
Hi! I have some weeks ago installed oracle 9.2.0.1.0 enterprise version. Now I need the transparent gateway for microsoft sql server 2000. I started the oracle universal installer on my oracle server and selected custom. There I selected oracle transparent gateways 9.2.0.1.0 for sql server. Now my problem: In the oracle 9i database window I see that 1 product (oracle database 9.2.0.1.0) will be deinstalled. Also under new installation is 1 product (oracle database 9.2.0.1.0) shown. Why makes the oracle universal installer a deinstallation of my oracle 9.2.0.1.0? I have nothing marked to deinstall. I have oracle enterprise version installed. When I add any software component of oracle is that the right way to do with the custom selection in the oracle universal installer window? Thanks! ...

optimizer_features_enable difference between 9.2.0.1/9..2.0.3/9.2.0.6?
Hi, All, I noticed for this parameter optimizer_features_enable , oracle document says: Syntax OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | 9.2.0} I noticed when I keep it default to 9.2.0 in init.ora, in version 9.2.0.3 and 9.2.0.5 with exact same database and exact same init.ora, oracle CBO did choose different plan. So there is some difference between 9.2.0.X versioin for the CBO. Where can we get such information about the difference? Thanks On 12 Jul 2005 23:37:28 -0700, "chao_ping" <zhuchao@gmail.com> wrote: > So there is some difference between 9.2.0.X versioin for the CBO. >Where can we get such information about the difference? Usually such things are outlined either in the release notes or in the new features documents. Documents that obviously no one reads. -- Sybrand Bakker, Senior Oracle DBA "chao_ping" <zhuchao@gmail.com> wrote in message news:1121236648.759298.79320@g44g2000cwa.googlegroups.com... > Hi, All, > I noticed for this parameter optimizer_features_enable , oracle > document says: > Syntax > OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | > 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | > 9.2.0} > > > I noticed when I keep it default to 9.2.0 in init.ora, in version > 9.2.0.3 and 9.2.0.5 with exact same database and...

Error in invoking target 'install' of makefile '/u01/app/oracle/product/9.2.0.1.0/network/lib/ins_net_client.mk'
Hi guyz, i was patching up from 9.2.0.4 to 9.2.0.6 on RHEL3 and unfortunately i came up with that error above. i was checking on Metalink but didnt get that much info. Most of the people were asking to check LD_LIBRARY_PATH which sounds like fine. Its a makefile issue. in my make.log it says collect2: ld returned 1 exit status make: *** [onrsd] Error 1 % echo $LD_LIBRARY_PATH /u01/app/oracle/product/9.2.0 ..1.0/lib i checked ld, which ld /usr/bin/ld from the log life i have got that collect2: ld returned 1 exit status make: *** [onrsd] Error 1 End output from spawned process. ---------------------------------- Exception thrown from action: make Exception Name: MakefileException Exception String: Error in invoking target 'install' of makefile '/u01/app/oracle/product/9.2.0.1.0/network/lib/ins_net_client.mk'. See '/u01/app/oracle/oraInventory/logs/installActions2006-12-12_11- 19-22PM.log' for details. Exception Severity: 1 i had that issue before but i just forgot how to resolve that issue. If anyone came across with that issue please let me know would be great help. Thanks in Advance guyz. Hasnain ...

ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7
Hye, While running an upgrade from 8.1.7 to 9.2.0.4 I finished the upgrade successfully I started the database and wanted to change undo tablespace management to be automatic So I offline the rollback segs, offline the tablespace that holds then and drop it. I want to create a new tablespace UNDO but I got the error the the parameter compatible is set to a lower value which is true because I have 8.1.7. I disconnect, delete the compatible entry from the file and want to log again. And here's the surprise ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7 I have the database backed up so I can restore but I am hoping there is a way that will save me some time. What can I do to eliminate this error ? TIA Michal What do you mean you deleted the compatible parameter ... Did you not set it to a new proper value For example "compatible=9.2.0.0.0" Or is there a reason you would not want to change it - which do exist. It says oracle version is 8i...and redo version 9i. Are you starting the database under right environment? Sorry, I was a little too quick on my post. I should have though about the possibility that you could be using the new server parameter file, in which case you might have to execute the following -> alter system set compatible="9.2.0.0.0.0" scope=spfile; ...

Error in installing Oracle 9i (9.0.1) on Redhat Linux 9
Hi, I am facing following problem in installing Oracle 9i on RHL 9 Error in invoking target install of makefile /home/oracle/product/9.0.1/plsql/ins_plsql.mk I have already tried the solution suggested for RHL 7.1/2/3 (editing genclntsh and removing -z defs and running this script). Even after this fix when I click Retry button I get the above error again. When I try to run genclntsh after removing "-z defs" I get this error. cp: cannot stat `/DISCARD/': No such file or directory Created /home/oracle/product/9.0.1/lib/libclntst9.a Any help will be appreciated. Thanks and Regards, Jitendra Agrawal. http://www.telemune.com/ ...

Oracle 9i Release 2(9.2.0.4) on Slackware 10.1
Does anybody out there have had these experience in performing such an installation ... does anybody have a how-to ... or some hints ... ??? Please help me with this issue. || So many thanks in advance, looking forward to hear from you guys .. !! Oralinuxdba wrote: > Does anybody out there have had these experience in performing such an > installation ... does anybody have a how-to ... or some hints ... ??? > Please help me with this issue. || So many thanks in advance, looking > forward to hear from you guys .. !! > Issue? What issue? The issue of using a non-oracle-supported OS is easily addressed: switch to White Box Linux. -- Regards, Frank van Bortel What's "White Box Linux" .... ?? Oralinuxdba wrote: > What's "White Box Linux" .... ?? > What's slackware? I know shareware, hardware, vapourware, software, courseware,... -- Regards, Frank van Bortel White Box Linux is: " forked from the source code for Red Hat's _Red Hat Enterprise Linux_" See: http://www.whiteboxlinux.org/ and remember ... Google is you friend for "What is" questions...... Oralinuxdba wrote: > What's "White Box Linux" .... ?? What's google.com? Apparently this is some inane American game show? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond) DA Morgan wrote: > Oralinuxdba wrote: > >> What's "Whi...

Oracle 9.2.0.1.0 Undo Management?
undo_manager is auto I try this ... conn user/password@ora92 update sometable set field1='1234567890', field2='1234567890'; SQL>update 100000 rows rollback; conn user/password@ora92 update sometable set field1='1234567890', field2='1234567890'; SQL>update 100000 rows rollback; conn user/password@ora92 update sometable set field1='1234567890', field2='1234567890'; SQL>update 100000 rows rollback; ..... I check UNDOTBS1 size, It grows up, every time! I test about 30 times; It still grows up :( It's management? How do I solve this problem? Thanks! Jackie Chang. Jackie, you have provided insufficient information in your post. What specific version of Oracle? I will guess 9.2 something from the connect string What are the undo tablespace parameters? You imply that it is set to autoextend. What query are you using to look at size? What value is undo_retention set to? How many megabytes of data does the update generate? Without knowing any specifics I will guess that Oracle extended the undo tablespace to be able to retain the data for the time period specified by undo_retention. HTH -- Mark D Powell -- Oracle 9.2.0.1.0 undo tablespace extend managment use LOCAL. I think the tablespace set to autoextend. I use Oracle Enterprise Manager Console check it! And check UNDOTBS01.DBF file size! Undo_retention to large(10800 9iR2 default), So Oracle does not reuse undo tablespace. Thinks a lot! Jackie...

Change IP address on Oracle 9i Aplication Server 1.0.2.2.2a
Hello, i'd like to know if is it possible to change IP address on win 2000 server and Oracle 9i Aplication Server 1.0.2.2.2a will work? It will be painful to reinstall everything. many thanks, Oc. Ocean wrote: > Hello, > > i'd like to know if is it possible to change IP address on win 2000 > server and Oracle 9i Aplication Server 1.0.2.2.2a will work? It will be > painful to reinstall everything. > > many thanks, > > Oc. > It's even more painful to change iAS 1.0.2.2.2a - believe me! Can't remember how, but I've managed to do it once, and it took far more time than re installation. Don't change the address - why would you? You can probably do some clever things with DNS. -- Regards, Frank van Bortel Top-posting is one way to shut me up... Thanks for tip with DNS...it's not problem with installing ias but we have some old oracle client applications from different company and all this to set up will be painfull.. regards Tilen ...

restoring 9.2.0.6 datafiles with 9.2.0.7 Oracle
Hello Is there potential problem ? we want to use old datafiles in 9.2.0.6 with a patched oracle in 9.2.0.7... Thank you nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... > > Thank you No, you don't want to do that. You want to solve some problem, for which you believe that to be the solution. What is the problem you are trying to solve? In answer to your question -- yes, I'd think there would be disasterous problems. So, again -- what is the problem you are trying to solve? nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... That really describes a usual step in applying the 9.2.0.7 patchset. The database files are still at ( whatever ) the old patch level was .... say 9.2.0.6. You have to use the patched oracle binaries to open the database. But then the next step should be to follow the steps in the 9.2.0.7 for patching existing databases ... startup migrate and run the script to move the database files up to 9.2.0.7 ... Is that what you are attempting to do? Have you read the readme ( installation instructions ) for the 9.2.0.7 patchset? ...

Installing patchset 9.2.0.8 on 9.2.0.1 error
The following running services need to be shutdown before continuing: Automatic Updates Background Intelligent Transfer Server COM+ Event System Cryptographic Services DCOM Server Process Launcher DHCP Client DNS Client Distributed Link Tracking Client Error Reporting Service Help and Support Messenger Network Connections Network Location Awareness(NLA) Remote Access Connection Manager Remote Procedure Call (RPC) Remote Registry Secondary Logon Server Shell Hardware Detection System Event Notification System Restore Service TCP/IP NetBIOS Helper Task Scheduler Telephony Terminal Services Themes WebClient Windows Audio Windows Management Instrumentation Windows Time Wireless Zero Configuration Workstation What should I do, while installing patchset 9.2.0.8 on WINDOWS XP, I am getting above error. "peter" <hhh.database@gmail.com> schreef in bericht news:1168424525.937552.232840@k58g2000hse.googlegroups.com... > The following running services need to be shutdown before continuing: > > Automatic Updates > Background Intelligent Transfer Server > COM+ Event System > Cryptographic Services > DCOM Server Process Launcher > DHCP Client > DNS Client > Distributed Link Tracking Client > Error Reporting Service > Help and Support > Messenger > Network Connections > Network Location Awareness(NLA) > Remote Access Connection Manager > Remote Procedure Call (RPC) > Remote Registry > Secondary Logon > Server ...

Where to get oracle patch 9.2.0.4 and 9.2.0.5
I'm doing an install for work on a windows xp (32bit) development station. To mimik the production systems I need to install 9.2.0.1.0 and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 and I have a disk for the patches but it is corrupted. Where can I get these patches? I've tried google to no avail. Thanks in advance! On 29 Jun 2006 15:13:24 -0700, "David.E.M....@gmail.com" <David.E.Murphy@gmail.com> wrote: >I'm doing an install for work on a windows xp (32bit) development >station. To mimik the production systems I need to install 9.2.0.1.0 >and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 >and I have a disk for the patches but it is corrupted. Where can I get >these patches? I've tried google to no avail. Thanks in advance! Patches are available on Metalink. And, yes, you need to have a paid support contract for that. -- Sybrand Bakker, Senior Oracle DBA David.E.M....@gmail.com wrote: > I'm doing an install for work on a windows xp (32bit) development > station. To mimik the production systems I need to install 9.2.0.1.0 > and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 > and I have a disk for the patches but it is corrupted. Where can I get > these patches? I've tried google to no avail. Thanks in advance! You get the patches from oracle http://www.oracle.com then go to the support link then metalink ... I&#...

Web resources about - oracle 9i (9.2.0.1.0) - sql analyze login error - comp.databases.oracle.server


web.forret.com - View & Analyze HTTP Headers
View & analyze the HTTP headers for any URL - caching,redirect,expiration

Facebook Introduces Telco Outcome Measurement To Help Telecommunications Firms Analyze Their Ad Campaigns ...
Facebook continued its efforts to help advertisers move beyond existing metrics and gain a true picture of their return on investment with Thursday’s ...

Customize, target, analyze: A Facebook mobile app install ad guide
... them. If there is a simpler way of explaining all of these steps, it would come down to this circular process: customize, target, and analyze. ...


Autism Tracker Lite: Track, analyze and share ASD daily on the App Store on iTunes
Get Autism Tracker Lite: Track, analyze and share ASD daily on the App Store. See screenshots and ratings, and read customer reviews.

TEDDY ATLAS SAYS CANELO VS. GOLOVKIN WON'T HAPPEN AND EXPLAINS WHY; ANALYZES GOLOVKIN'S SKILLS - YouTube ...
"I don't think it's going to happen...that's a nice piece of meat to throw at you to keep you at bay...Canelo has too many options...he's got ...

Judge Napolitano Analyzes Rand Paul and Marco Rubio's CPAC Speeches: 'They Were Superstars' - YouTube ...
Today, Senators Rand Paul and Marco Rubio both spoke at CPAC. Judge Andrew Napolitano reacted to their speeches on tonight's Special Report calling ...

FBI analyzes data deleted from flight simulator of Malaysia Airlines pilot
The FBI joined forces with Malaysian authorities in analyzing deleted data on a flight simulator belonging to the pilot of the missing Malaysia ...

Tim Gunn's Fashion Bible: The 'Project Runway' Host's 10 Tips To Analyze Your Wardrobe And Style
If there's someone out there who knows what will make or break a wardrobe better than Tim Gunn, we want to meet him or her. Known, most popularly, ...

Resources last updated: 3/20/2016 7:54:58 AM