My manager is asking to create a SQL scrip, which will provide following information.
Our database is 9.2.0.7.0 on Windows 2000 Server
-How many records Insert / Update or Delete daily in my Oracle database?
- Check Archive log / Redo Log switching information?
-Check database growth ?
I am doing export from Oracle 9.2.0.8 windows 2000 prof.
Exporting command
exp <>/<>@<> file=<> log=<> owner=<>
and get error in export log
. exporting synonyms
. exporting views
. exporting stored procedures
EXP-00056: ORACLE error 1410 encountered
ORA-01410: invalid ROWID
EXP-00000: Export terminated unsuccessfully
i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).
All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.
I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.
View 3 Replies View RelatedWhen I monitoring db, I see open cursor increase from a machine running Java application. On the develop machine, everything is ok, but on the production server, open cursors can not close.Although the parameters are the same on 2 servers.
View 15 Replies View RelatedI have version 11.2.0.3 installed in a server AIX and i'd like to know where are alerts and logs like "max extents reached in table....". I don't see them in alert.log.
Where is the best way to monitoring this class of alerts and logs?
How can i see how many actuals extents go consumed in tables and indexes?
How monitor the unusable objects in oracle 10g (10.2.0.1.0) os rhel 5? is it same as invalid objects and can be monitor as same?
View 4 Replies View RelatedI am using TOAD to monitor user sessions. I have a user who uses nearly 80% of Overall resources in the mornings. He calls me daily and say that his work is done. But even then the TOAD shows that he is using same resources for some time.
My question is can i kill the session once he confirms his work is done OR do i need to wait till the redologs are cleared.
Currently all my tablesapces are "UNIFORM" and I am looking into going to "AUTOALLOCATE" so space will not be some much of an issue.
I am using the following code and here is the output
sqlplus -s / <<-EOT
set pages 50
set line 100
set verify off
set feed off
set trimspool on
[code]........
Have a script that can emulate my above output and also deal with tablespaces that can autotallocate?
We have 2 Unix SunOS server, named as SUNOS01 and SUNOS02, there is some space need to add in SUNOS02 and for that I have to bring Database down on SUNOS02. When I checked I found that the DB is pointing to SUNOS01, i.e. there is no DB on SUNOS02, So, Do I required to shutdown the DB on SUNOS01 or it is not required to do anything from Database side. I mean to say should I ask Unix team to bring down the unix server and add the space.Also, if DB shutdown is not required then what I have to do afetr they have added space and bring the server up from DB side.
View 4 Replies View RelatedI have one question regarding privileges required for export.I read in a document that
Quote:
If you do not have the system privileges contained in the EXP_FULL_DATABASE role, you cannot export objects contained in another user's schema. For example, you cannot export a table in another user's schema, even if you created a synonym for it.
what are the system privileges required in EXP_FULL_DATABASE role to perform export objects contained in another users schema?
tips to install the ORACLE 10g,developer 2000 in Windows 7 64 bit.
View 3 Replies View RelatedI have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.
1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.
However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.
Is a fresh install the only option? or is there any way to correct this using the sys/sys user?
I found some of the tablesapces whose used% exceeded 80%.Based on this output i thought of increasing the datafile.But there are many tablespaces of DATA1 whose autoextensible column some are set to NO, and some are set to YES. I believe we dont need to bother about the tablespace whose Autoextensible column set to YES as Oracle will automatically manage until the Maxsize of it. But some tablesapce of DATA1 are set to NO. Should i recommend to add size for this DATA1 tablespace whose autoextensible are set to YES/NO or leave it as it is.
Please see the column below.
Quote:
FILE_IDTABLESPACE_NAMESIZE(M)USED(M)FREE(M)MAX(M)AUTOEXTENSIBLE% USED
59DATA13276732741.1325.7532767YES100
60DATA13276732741.6925.1932767YES100
61DATA1327673274026.8832767YES100
76DATA13270032193.31506.560NO98
77DATA13270030858.51841.380NO94
78DATA13270029476.563223.310NO90
I already succeded to setyup Oracle 10 G on my machine , when trying to connect by system/system it does not connect.The listener is OK and instance ok.
View 10 Replies View RelatedHow to verify if rebuild an index is required in database.
View 9 Replies View Relatedknow whether Oracle 9i works in Windows 2012? As we are planning to upgrade.
View 1 Replies View RelatedWith just the ip address available, how to install the oracle 11g software on windows 7? What are the access I will need in order to Install the oracle 11g software and create the oracle 11g database on windows 7?
View 7 Replies View RelatedI need to install Oracle 10g in windows 7 home premium which version of oracle 10g will work better with Windows 7 home premium. I need to download «& install.
View 5 Replies View RelatedI have a 11g database installed on a windows 2003 server. When I created the database I could not assign more than 2GB for SGA_TARGET where as I have 16GB of RAM available on the server. I created the database with SGA_TARGET as 1.5 GB and Memory_TARGET as 2GB. I could create the database successfully. Later when I again tried to increase SGA_TARGET to 6GB and MEMORY_TARGET to 8GB, I could not start the database. I got below error;
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command
Quote:I added /pae in the boot.ini
Added AWE_WINDOW_SIZE key to registry as 2000000000
Set use_indirect_data_buffers=true
added db_block_buffer=131072 (ie. 2GB DB_BLOCK_SIZE=16kb)
java_pool_size= 1000M
large_pool_size=1000M
shared_pool_size=2000M
I got again the same error
I could not use SGA_TARGET. So is AMM not allowed with AWE?
My problem is when trying to use oradmin.exe. It doesn't exists apparently. I have Database Creation Assistant and Net Creation Assistant, I can open and run sqlplux.exe and run sql commands, but oradmin.exe seems to be missing.
This is a new install of Oracle EE 11gR2 on Windows 7 Pro.
what is the Minimum datafile size required for creating a non-system tablespace?
I am trying to create a tablespace by giving the syntax like,
SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 72k;
create tablespace t1
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 73k;
Tablespace created.
The blocksize for my database is 4096, as i have heard that the minimum size of the datafile is decided by blocksize, but i want to know that how it is calculated as by giving the above syntax the other values will be default. I am trying the syntax in oracle 9.2.0.1.0 version.
I want to install Oracle EE 11gR2 on my Windows 7 Professional 64-bit laptop. Installed memory is 8GB.I need to install 32-bit server since Oracle Warehouse Builder will not run on a 64-bit o/s. Further, I use Toad 9.7.2 which will only recognise client 32-bit.
I had a few failed attempts, especially when the database was being created with the ORA-12560: TNS:protocol adapter error,
So here's what I did:
Changed C:WindowsSystem32driversetchosts so that it contains two lines 127.0.0.1 localhost & ::1 localhost
Changed properties of setup.exe in the installation directory to be Windows XP SP2 compatible and run as administrator
Selected "install database software only" (so I could figure out at what step the installation fails)
Selected "single instance"
Selected "Enterprise Edition"
Selected oracle base "c:app" (instead of default location c:appd_seng)
Copy of files was completed successfully, log file was created in c:program files(x86)oracleinventorylogs & registry entries were added to "HKEY_LOCAL_MACHINESOFTWAREWow6432NodeORACLE" (with keys KEY_OraDb11g_home1, ODP.NET & OracleMTSRecoveryService), and the following services were created:
OracleMTSRecoveryService: Started/Automatic
OracleOraDb11g_home1ClrAgent: Not started/Manual
OracleRemExecService: Started/Disabled
There are no listener.ora & tnsnames.ora yet. Sqlnet.ora is created with the line SQLNET.AUTHENTICATION_SERVICES = (NTS)
Now I went to Start, All Programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Net Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it. I selected "Listener Configuration", added a listener called LISTENER, TCP protocol, port 1521 and finished. A service called "OracleOraDb11g_home1TNSListener" was created and started in automatic mode. The PATH was updated and listener.ora was created with the lines:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:appproduct11.2.0dbhome_1)
[code]...
Tnsnames.ora is also creaed with the contents:
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
At the command prompt, lsnrctl.status shows:
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:42
:19
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 15-APR-2012 12:37:54
[code]...
At the command prompt, lsnrctl.services shows: LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-APR-2012 12:43:15
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DSG-HP6555b)(PORT=1521))
)
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully Now I went to start, all programs, Oracle - OraDb11g_home1, Configuration and Migration Tools, right clicked on "Database Configuration Assistant" and changed the properties to be Windows XP SP2 compatible and run as administrator and ran it.
I chose to create a databaseGeneral purpose Global database name ORCL SID ORCL Chose "Configure Enterprise Manager" & "Configure Database Control for local management" and disabled "Automatic maintenance tasks" Used the same password for all accounts
Selected storage type "File System" & "Use Database File Locations from Template" Unchecked Flash Recovery & Archiving Selected "Sample Schemas", "Typical" memory size (1228MB), "Use Automatic Memory Management" Left sizing/character sets/connection mode as default, and Selected "Generate Database Creation Scripts" in C:appadminORCLscripts (if I choose to Create Database, it fails with TNS Protocol Adapter Error).
I now open ORCL.bat in an editor, go to command prompt, create the directories as per the file, set ORACLE_SID=ORCL & path.
Running C:appproduct11.2.0dbhome_1inoradim.exe -new -sid ORCL -startmode manual -spfile gives a message "instance created" & services "OracleJobSchedulerORCL", "OracleVssWriterORCL" (started) & "OracleServiceORCL" (started) are created.
The next step C:appproduct11.2.0dbhome_1inoradim.exe -edit -sid ORCL -startmode auto -srvcstart system give an error "Unable to start service, OS Error 1056" (probably implies services already running), nothing is present in the windows alert logs about this. If I stop the service OracleVssWriterORCL, then this command completes, although no messages are returned.
The next step in the batch file starts sqplus /nolog and calls ORCL.sql.
ORCL.sql accepts passwords for sys, system, sysman & dbsnmp. It then executes host C:appproduct11.2.0dbhome_1inorapwd.exe file=C:appproduct11.2.0dbhome_1databasePWDORCL.ora force=y, which prompts me for the password for sys.
ORCL.sql then calls CloneRmanRestore.sql, which then tries to run connect "SYS"/"&&sysPassword" as SYSDBA
This is when I get the error ORA-12560: TNS:protocol adapter error, which has been haunting me for days.
My gut feel is that the database creation step at sqlplus is unable to recognise the listener...or probably it does not recognise the modified registry location (with Wow6432Node), the file oracle.key in C:appproduct11.2.0dbhome_1BIN shows the string SOFTWAREORACLEKEY_OraDb11g_home1.
I then changed oracle.key to point to SOFTWAREWow6432NodeORACLEKEY_OraDb11g_home1, restarted the listener and ORCL service, but connecting as sys returns the same error.
I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .
View 22 Replies View Relatedworking on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.
View 6 Replies View RelatedI wanted to transfer my database from Oracle 11.1.0. on windows 2003 server 32 bit to Oracle 11.2.0. windows server 2008 64 bit
i have done following
1)On new server of 11.2.0 windows 2008 64 bit use rman backup from Oracle 11.1.0. on windows 2003 server 32 bit to restore the database and recover the database when i try to open the database Alter database open it gave me message that i should start my database as upgrade I start the database with upgrade
STARTUP UPGRADE and then run following
@?/rdbms/admin/utlirp.sql
and then run following
@?/rdbms/admin/utlu112i.sql
and then run
@?/rdbms/admin/catupgrd.sql
during run of catupgrd.sql after around 30 minutes of run, i got error
ORA-03113: end-of-file on communication channel
but i reconnected myself with database again and shutdown the database and open it in normal mode and it has opened there were thousands of uncompiled objects and i recompiled them.
Only uncompiled objects left 60 are 'OLAPSYS' (Locked user) USER and 30 of PUBLIC user (all Synonyms)
Have i taken correct steps?
What should i do now to check that everything will be alright in future
I have installed 11g R2 on windows 7 32bit then I uninstall it through deinstall but now again i am installing it it says
Cause - The chosen installation conflicted with software already installed in the given Oracle home.
Action - Install into a different Oracle home.
How can I remove that Oracle Home.
I cannot run a Scheduler remote external job on Windows. Here's what I'm doing:
--Check that XDB isinstalled:
desc resource_view
--Check that MTS is running
sho parameters dispatcher
sho parameters shared_Server
--Setup an http listening port:
exec dbms_xdb.sethttpport(8080)
[code].....
This is the error:
orcl> select job_name, status, error#, actual_start_date, additional_info
2 from user_scheduler_job_run_details where job_name='TRYIT';
TRYIT
FAILED -1.074E+09
15-JUN-11 02.16.54.583000 EUROPE/LISBON
[code].....
I am certain that the communications and the credentials are correct, I've tried variants and get different errors. I think the problem is the job action. I've tried running batch files as well as OS commands, same result. THere is nothing useful in the core dump. Is there perhaps a Windows specific technique for running external jobs? Some way of nominating the batch file, or specifying a command interpreter?
We are applying PSU JAN 2011 patch 10349197 on windows server 2007. While applying the patch we are getting the below error.
Following files are active :
E:oracleproduct10.2.0inoraclient10.dll
E:oracleproduct10.2.0inorapls10.dll
E:oracleproduct10.2.0inoracommon10.dll
E:oracleproduct10.2.0inorageneric10.dll
E:oracleproduct10.2.0inoraplp10.dll
[code]........
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67620:Interim patch 10349197 is a superset of the patch(es) [ 8559466 ]
in the Oracle Home
--------------------------------------------------------------------------------
Its not an rac. We stopped all the services running on this server.
OPatch failed with error code = 74