i have win 2008 server and oracle 10g when im try to install oracle it terminate successfully but when insall domain controller in windows , oracle dont terminate the installation and break in creating data base (2%) and return the error message : ora-12560 tns adaptator protocol error
View 1 RepliesSince 13.00 hours, my clients can't connect to the database, and hence cannot access their application.
They get a ORA-12560 error. protocol adapter.
What I have discovered and done so far.
1. I can tnsping dbname -> OK.
2. I have rebooted both application server and databaseserver multiple times
3. I haven't touched tnsnames.ora, sqlnet.ora and listener.ora and they look to be in perfect mint condition.
4. I have full access to access the database instance via web.
5. I can connect to the database instance via sql
6. I have restarted the oracle-services: oracleDBConsoledbname, OracleOraDb20g_home1TNSListener and OracleServicedbname
7. I have rebooted the client computers, and the file server.
8. I don't see any errors in event logs, both on file server, client computer and database-server.
9. When I press down the link Listener, I get Metric Collection Error, which means I might not access it?
10. The only alert I find is that filesystem D: only has 15.62% available space.
They have been using the database for a very long time without any trouble, and suddenly boom.What do I do? How do I check things?
i want to create new database in oracle 10g, i follow following steps.
C:ORACLE_SID=ALI
THEN create passwordfile
orapwd file=orapwdALI.ora password=ali entries=6
then create oracle instance
C:Oradim -new -sid ALI -STARTMODE AUTO
after that i use
SQLPLUS /NOLOG
THEN i write the command to connect to user ali but
CONNECT SYS/ali as sysdba
it display following message.
Error
ORA-1256: TNS: protocol adapter.
i also check the oracle services from "services.msc", where oracle instance is "start".
In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.
In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.
Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :
ERROR:ORA-12560: TNS:protocol adapter error
In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?
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 RelatedI 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 1 Replies View RelatedWe have been upgrading our servers to Server2008 and are getting..
[ORA-3134: Connections to this server version are no longer supported.]
..using the drivers we used to use in XP and Server2003 to access a legacy Oracle7 db. Connections to this db are needed for typical CRUD functionality by multiple applications, some written in Classic ASP and some in C# .NET 3.5 & 4.0. I have tried ODBC drivers (System.Data.Odbc) and also ODP (Oracle.DataAccess.Client) to no avail.
Any existing driver solution to make this connection without have to resort to a custom HLI interface?
I would think we aren't the only ones needing to access Oracle7 from Server2008.
I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>
but then it says oplan is not recognized. I have set the Oracle_home and path variable
my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan
Note that my database version is 11.2.0.3 with ASM
I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:
Checking Operating system version: must be 5.0,5.1,5.2 or 6.0
Actual 6.1
FAILED <<<<
Exiting Oracle Universal Installer
Press any key to Exit.
We installed Oracle 11g on solaris machine but some of the configuration failed.
When verified in tracelog we are finding below error message:
PRCT-1003 : Failed to run "getcrshome" on node "localnode"
at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:423)
at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:546)
at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:606)
at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:347)
at oracle.sysman.assistants.dbca.ui.DBCAWizard.<init>(DBCAWizard.java:452)
[code]....
We then tried to create instance but came up with below error:
ORA-12560: TNS Protocol Adapter Error..We have another database version 10.2.0.3 running on the same server and needs to be continued.
When connecting to Oracle Db as sysdba the following error message occurs.
-bash-3.00$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 27 00:34:55 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/sys as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
how to create a new database in oracle??
View 2 Replies View RelatedI have created a database in Oracle10g which is working fine. Now when I try to create another the system gives the following error.
ORA-12560: TNS protocol adapter error.
I installed Oracle 11gR2 withouth creating a database in my laptop. Later when I tried to crete the database using DBCA it shows error ORA-01078:failure in processing system parameters.I clicked on ignore error, then shows the error ORA-01034: Oracle not available.
View 4 Replies View RelatedI've been working to create (via script) this database for the last 2 days.. everytime I startup in nomount mode (as sysdba), it displays this error:
$ echo $ORACLE_SID
elams
$
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 7 09:41:26 2011
[code]....
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.
using pl/sql code i am creating text file on specific path of database server. i need to compress this file .how to compress the text file using pl/sql?
View 1 Replies View RelatedI am getting a ORA-03114 (not connected to Oracle) error when I am creating a DB using DBCA. Here are the steps that I do:
1) Log onto the server remotely, using Exceed Query
2) Connect as the oracle user (Oracle)
3) set ORACLE_HOME, PATH
4) Run DBCA, give parameters
At around 12% and again at 19%, I get the error (see screenshot). I also tried to generate the scripts and run them remotely, and the steps run successfully upto & including the step " startup nomount pfile="/oracle/admin/<dbname>/scripts/init.ora"; ". After that, when I try to run the script specified in rmanRestoreDatafiles.sql from SQL> prompt, the error appears, and connection to ORACLE is lost.
Googling the error shows that it is a connectivilty issue, and Oracle says that it is usually caused by user scripts. But I am not running any user-created scripts as part of the DBCA process. Somehow, the instance is timing out immediately after doing the "startup nomount".
This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6
I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.
during the database creation I got an error as the system was adding the JVM that read:-
ORA-01927:cannot REVOKE privileges you did not grant.
I was given the options to ignore or abort
I chose to ignore the error and continue.
After the database creation completed I looked in the jserver log copied below and found two errors
I did not get the same error before installing patch set 6
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv
[Code].....
I am trying to create the Physical StandBy Database in the same server. Till last 2 Final steps, everything went on well. In the final steps, when I try to open the StandBy Database, it throws the following Error:
*******************************************************
SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
I tried creating the Physical Standby with the following Steps.into that & tell me whether I have done any mistake.Also tell me any step I have missed from the following list of steps:
Environment: Oracle Release 10.2.0.1.0 / Windows 2003 Server Enterprise Edition SP2
Primary DB = 'PrimDB'
StandBy DB to be created = 'StBy1DB'
In the same Server, location for
PrimDB datafiles = 'F:\oracle\product\10.2.0\oradata\PrimDB\Data\',
StandBy Datafiles = 'E:\StandBy_DB\Data\'
[code]...
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
I installed Oracle 10g (10.1) in Windows Server 2003 and i am able to connect to oracle using using SQL net. But when I tried to connect this using SQL Net from Windows XP, I am getting ORA-12560: TNS:protocol adapter error. But when I tried to connect as SYSDBA user, I am able to login in SQL plus. But for a normal user, not able to log in.
View 1 Replies View RelatedI 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 RelatedOracle 11g R1 or R2 is availble for Windows Server and If YES then any link for the same.
View 2 Replies View Relatedcan connect a 64 bit Oracle 11g Release 2 on a Windows 7 client with a 32 bit Oracle 11g Release 2 on a Windows 2008 server?
View 5 Replies View RelatedI'm installing Oracle 10g (10.2.0.4) RAC on Windows enterprise Server. Am able to install cluster ware (10.2.0.4). While installing ASM (10.2.0.3)/ DB its going to restart both the servers automatically. Is there any problem with this Versions (OS and Oracle) combination. Is it compatible or Not?
View 4 Replies View Relatedis Forms [32 Bit] Version 10.1.2.0.2 not supported with Windows Server 2008 64 bit ?? i tried to install it and it was failed.!
View 2 Replies View RelatedOn windows 2008, need to schedule task for database backup.
View 4 Replies View RelatedHow to install oracle 11g in Window Server 2008 R2.
View 6 Replies View RelatedEM displays: Enterprise Manager is not able to connect to the database instance
And yest the Database Instance status show open and the instance is up; Listener status is Up; Agent Connection to Instance status is Succeeded (but no details)
emctl status dbconsole shows ""Oracle Enterprise Manager 11g is running"
emctl status agent shows "Agent is Running and Ready"
I can connect with SQL Developer and see everything in the database.