I am trying to install oracle 11gR2 64-bit on windows XP 64-bit Operating System, after the completion of the steps where I have to enter the path for the ORACLE BASE and other parameters when I click next and then Finish, I receive an error, you can check in the attachment.
View 11 RepliesI am trying to install Oracle 11g R2(64bit) on Windows 7 64 bit OS. While Creating Database using DBCA. I am getting error. Below is the screenshot.
Below is the error in the Trace file...
oracle.sysman.assistants.util.step.StepExecutionException:
Error in Process: C:Oracleapporacleproduct11.2.0serverinorapwd.exe
Unable to find error file %ORACLE_HOME%RDBMSopw<lang>.msb
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.
unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Userssandifer>emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
C:Userssandifer>SET ORACLE_HOSTNAME=localhost
[code].....
I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.
I have an issue during the database configuration using DBCA at 85% it blocs, then it displays an error asking to reconfigure ORACLE_UNQNAME.
View 6 Replies View RelatedI downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).
View 10 Replies View RelatedI have facing a error message(attached) while creating or installing database in my system.
find attached error snap for the your reference only.
We are planning to have new installation of 11GR2 and would like to create data guard for this system. I have one server in Houston and other in Austin TX. the OS will be Windows 2008 R2.
How can i set up data guard and what is the requirements?
I installed oracle 9i from cd's (3 cd pack) all the three cd's installed perfectly but after the installation of these three cd's , a window appears (which is default installation ) in which some below mentioned tools were installed:-
1. Net Configuration Assitant
2. HTTP server etc. when installation of net configuration assistant is going on then a window is popped up saying "jrew.exe stops working" and the process of installation keeps going on and going on..........then when i stopped listener ,then another tool installation starts and after sometime again a window is popped with same message "jrew.exe stops working". means all the 4 tools are not successfully installed ...installing oracle 9i database on windows7.
I am getting error while installing Oracle 11g on windows xp. Ora --12638: Credential Retrieval failed error. I understand that some people have got that error after the installation( Changing SQL.Net file).
View 9 Replies View RelatedI am installing RAC 11GR2 in VMWARE on OEL 6.3. Everything went smooth but when i tried to configure ASM , I get below messages.
[oracle@RAC1 ~]$ /etc/init.d/oracleasm configure-bash: /etc/init.d/oracleasm: No such file or directory.
I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.
On Database Server
SQL> create directory win_expdp_dir as 'd:expimp';
Directory created.
SQL> grant read, write on directory win_expdp_dir to lab;
Grant succeeded.
On Windows 7 machine (client machine)
D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.
I have a virtual machine which have Windows Server 2008 R2 Datacentre 64-bit.
When I install Oracle Database 11gR2 and click on "SETUP" file, a message box namely JAVA VIRTUAL MACHINE LAUNCHER and display below error;
_"Could not find the main class. Program will exit."_
Same setup runs successfully on my server with Windows Server 2008 Enterprise.
Is it 11gr2 supports a virtual machine which have Windows Server 2008 R2 Datacentre 64-bit ? or some other?
I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:
[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory.
CAUSE: The central inventory location provided is not empty.
The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.
I am running this command to install oracle:
/runInstaller -silent -ignorePrereq -showProgress -waitForCompletion -responseFile /tmp/db_install.rsp
drwxrwx--- 6 oracle oinstall 4096 Apr 2 10:42 oraInventory
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:39 ContentsXML
drwxrwx--- 3 oracle oinstall 4096 Apr 2 10:41 backup
drwxrwx--- 2 oracle oinstall 4096 Apr 2 10:41 logs
[code]....
How can i set db home name at the time of installation of oracle 11.2.O.3 .
View 3 Replies View RelatedI have some confusions regarding to 11gR2 RAC installation:
- Is Grid Infrastructure only the solution to install Clusterware Application 11gR2? My requirement is to install only the Cluster ware Software for 11gR2 (For 11gR1 we have "linux.x64_11gR1_clusterware.zip") using ocfs2 file system, Archive Mode not enabled.
i have installed oracle 11gr2 on centos 4.7,,but after that when i invoke command for startup in sqlplus for sys user it shows an insufficient privileges error. and what are the post installation tasks? is the database installed also?what is the name of database and where is it?
View 5 Replies View RelatedI created Virtual Private Network for VIP and subnet is 255.255.255.255. I need VPN subnet as 255.255.255.0. How to i create
INS-40911: Ensure that nodes in the list are up and reachable, and ensure that the node addresses are all in the same subnet.
I want to install an active / passive Oracle Configuration for our new 11gR2 system. We do not want to go full blown RAC as yet. We already have an 11gR2 instance that I plan to CLONE to the production server(s).
So. detail the steps that I need to follow .
i.e.
configure the 2 servers (VIFs/Interconnects)
Install GRID/CRS
Clone over the database (do I do this as a SINGLE NODE RAC?)
can i install oracle 10g at windows 7 ultimate 32 bit
View 1 Replies View RelatedMigrating the LIVE server to a NEW virtual machine.2 databases reside on the LIVE server, one runs in archivelog mode &other no archivelog modeOld server-Windows 2003 32 bit, oracle databases 11.1.0.7.0New-Windows 2008 64 bit,Oracle databases should be 11.2.0.3.0Just want to clarify the following1)When installing oracle, what would be the best option-create and configure a database / install software only(later create database using dbca) ?why? Just want to know if there will be a difference at all in these 2 methods.2)What is the best way to migrate the data in the database, datapump or rman (rman takes full backup in the present "live" so this can be moved to "new live" and can be recovered)? What would be the method with least downtime?(Once the data is transferred, the database in the "old server"will be deleted)3)The structure of the data files (folder path) are going to be different in the old and new servers, so I have to precreate the tablespaces, so will the impdp fail in this case?
View 1 Replies View RelatedI tried to install 11gR2 grid infrastructure for 2 nodes RAC using VMWare as per the instructions provided in the below link.
[URL]
Until 65% installation went fine without any issues but after reaching this step "updating '/u01/app/11.2.0/grid/install/cluster.ini",it starts to hung. In the installation log file, I found these details.
Quote:filename = /tmp/.GsdDisplayed
INFO: Query Returned: false
INFO: Calling Action fileActions10.2.0.6.0 appendStringToFile
source = /u01/app/11.2.0/grid/install/cluster.ini
stringToAppend = [cluster_info]
cluster_name=rac-scan
[code]....
I am having 2 data centers within 1/2 km distance. And we kept each vote disk in once site. In case of site failure, the cluster needs a 3rd set. We don't have 3rd site.
Last open world, Oracle announced that oracle storage on cloud as announced. If I get the small space on the cloud, can i put my 3rd vote disk on the cloud?
I am using 11gR2 on windows server. This is the query that runs many times a day and effect badly the performance of database. I don't have much idea about this query.
SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count
FROM sys.dba_audit_session
WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')
I am trying to install Oracle 11g R2 on Windows 7 professional at the time of database creation they give error.
ORA-12638:Credential retrival failed.
Question: to migrate from oracle 10gR2 in Windows to oracle 11gR2 in Linux . Steps are:
1. need to expdp all schemas/users from oracle 10gR2 in Windows,
2. then impdp each schema/user into oracle 10gR2 in Linux first,
3. then upgrade the oracle 10gR2 in Linux to oracle 11gR2 in Linux ?
4. Do I need to pre-create all the same tablespaces first in oracle 10gR2 in Linux ?
Is it correct ? or I can migrate straight all schemas/users from oracle 10gR2 in Windows to oracle 11gR2 in Linux using impdp ?
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies View RelatedMy 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.
We are having major differences in performance when accessing an Oracle 11gR2 database from two different environments.
I won't sadden you with the gory details of the full application but I will use an indicative example of our problem.
We have SQL Developer in both environments. In each of these SQL Developer instances is a defined a connection to the same database on another machine. So there is the PC looking at a database and a virtual instance looking at the same database.
Selecting the '+' sign next to 'tables' for that connection, on the PC the list of four tables comes back in 4 seconds but on the virtual instance the list of the same four tables comes back in 1 minute and 50 seconds.
This sort of timing issue is repeatable for all accesses to the Oracle database on the third machine.
here is the error faced when installing oracle 11gR2,
ERROR:
Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/.colorls9rT/OraInstall2013-09-12_03-59-57PM/jdk/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1751)
[code]...