Server Administration :: Installed Database Oracle With Installation
Nov 17, 2011
Yesterday i installed oracle 11g r2 by default i installed database Oracle with the installation .but today i tried to create the database with the name green tat also completed successfully..the problem is in startup
export oracle_sid=green
sqlplus '/ as sysdba'
startup
database mounted
select instance_name from v$instance; But it SHowing the instance name as Oracle...i tried with the other method also
export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba
database mounted
select instance_name from V$parameter;
and it shows instance name as green..i tried to see the datafile location for green database
select file_name from dba_data_files; it shows the orcl datafile locations.
Are there any good information about on how to move a 10g database to a new server? We will keep the same disks on the SAN, but make a new installation on the new server.
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.
I am trying to install oracle 11g on windows 2003 ent with sp2 , where I am getting an error, The java runtime environment was not found at bin/javaw.exe. hence the oracle universal installer cannot be run.
I want to install Oracle software 10g R2 at linux platform. I want to install it at Silent mode, but not able to find the .rsp(response) file. I have created the .rsp(response file) from oui , hut not able to configure the same.
I want to install the partitioning option in my oracle database. I have the license. When i run the installer and select the partitioning option, the installation begins from beginning overwriting my old setup files. How can i avoid this and only install partitioning.
I am using Oracle 11g (11.2.0.1.0) and I want to apply January patch on 11.2.0.1.0. I have applied 3 patches. I have single Instance with ASM and Grid.
1. Applied Opatch on grid. unzip p6880880_112000_LINUX.zip -d /opt/grid/11.2.0/grid
2. Validated the Oracle Inventory. /opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/grid/11.2.0/grid
3. Shut down the databases. 4. Run the prepatch script ./9655006/custom/server/9655006/custom/scripts/prepatch.sh 5. Shutdown the ASM. 6. Ran the below command to stop CSS etc. /opt/grid/11.2.0/grid/crs/install/roothas.pl -unlock
8. Applied Opatch on Oracle home 9. Applied Oracle patch /opt/oracle/product/11.2.0/db/OPatch/opatch napply -oh /opt/oracle/product/11.2.0/db -id 10248516
8. Run the postpatch script ./9655006/custom/server/9655006/custom/scripts/postpatch.sh
9. Run the following script to enable CSS etc. /opt/grid/11.2.0/grid/crs/install/roothas.pl -patch /opt/grid/11.2.0/grid/bin/crsctl check has /opt/grid/11.2.0/grid/bin/crsctl check css
10. If CSS is not online ran the below command. /opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1" /opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1" /opt/grid/11.2.0/grid/bin/crsctl stop has /opt/grid/11.2.0/grid/bin/crsctl start has
11. Up the ASM and Databases. Ran the postinstall in GRID and Oracle. @catbundle.sql psu apply
12. Ran the below command on grid and Oracle. /opt/grid/11.2.0/grid/OPatch/opatch lsinventory /opt/oracle/product/11.2.0/db/OPatch/opatch lsinventory
1. Let me know steps which are followed are right because I didnot see the version change after connecting to database? (for example 11.2.0.1.0 after applying I can see 11.2.0.1.4 but not changed the version). How should I know the patch is applied properly?
I have installed grid and oracle 11g on linux environment. I want to installation January patch related to grid and oracle 11g. This is the first time i m going to install the oracle 11g.
When Oracle was installed, there was an error in the server's domain name (missing a "."). Is there an easy way to fix this domain name in the Oracle installation after the fact? I know about tnsnames.ora, pfile, system parameters, and I'm pretty sure I can do emagent -config. My concern is that the "Installed Products" would not like the fact that the domain name is now "abc.proj.org" when installation was done on "abcproj.org". The /etc/hosts file had "abcproj.org", and we want to fix it to "abc.proj.org".
I need to reinstall Oracle -- is there a better way?
A link which describe step by step with screen shots how can i install oracle 10 r2 on oracle linux server release 6.1 using vmware workshop 8.my actual os is windows server 64 bit in this in install vmware 8 and i install oracle linux server release 6.1 32 bit now i want to install oracle 10g r2 or oracle 11g r2 on this .
I am trying to install Oracle 11g Release 2 on Redhat Enterprise Linux 5.2 (vmware image) but after 50% installation it through errors while copying files on the server. I also tried on Windows 2003 Server R2 (physical m/c as well as vmware image) and faced same problems. I did installation of Oracle 11g Release 1 and didn't find any problems.
I am new in oracle I have installed Oracle in work group, while i work group it is working fine. But latter I have change the server from work group to domain. At that time Oracle was not working , not able to connect.
After that I change the Domain to work group again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc
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:
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.
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.
1. oracle 11gr2 64 bit database software installed 2. oracle 11gr2 32 bit clinet software installed
The above software has been installed on server, Pop pup- Error messages coming during installing 3rd party software packages...on server.
Error is - igrORASPConnect412.dll not register...
what could be issues & how to resolve this problem? do we need to reinstall client software again not available this DLL file after searching on oralce home directory .
Can i have 2 versions of oracle database installed on same server under one user on AIX also on windows,
Currently we have oracle 10.2.0.4.0 installed on AIX server, can we install oracle 11gR2 on the same server under on user, & both the versions will be in use.
How to manage the profile of the user having 2 oracle versions on AIX & on windows how to handle it.
I have downloaded and install oracle server6 and followed the
[URL].......
but i am getting error as follows
./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 42983 MB Passed Checking swap space: must be greater than 150 MB. Actual 7951 MB Passed Checking monitor: must be configured to display at least 256 colors Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation, Continue? (y/n) [n] n
User Selected: No
I have tried #export DISPLAY=localhost:0.0 #export DISPLAY=localhost:0.0 xhost: unable to open display "localhost:0.0"
My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...
I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.
So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...
That is for express version only.
My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?
I 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).
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 am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server. 2. I invoked "sqlplus" from another unix box to login to the database. 3. I found that the process id (ps -ef |grep sqlplus). 4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID, SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM, SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID FROM SYS.GV_$PROCESS, SYS.GV_$SESSION WHERE SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST' and SYS.GV_$SESSION.MACHINE like '%hostname%'
I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
I am connected as System. It was the only user I set-up a password when installed the database on personal computer.
SQL> alter user sys identified by mypass007 2 / User altered. SQL> connect sys/mypass007 ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.
after a long time,(i never remember when was the last time i installed 9i)i was asked to install 9i.So, whether i install server or cilent i get this error <attachment>
after i ignore it and finished the installation,The server installation gets abruptly ended for the client i get TNS errors.
