Monday, November 5, 2012

ora 12560 tns protocol adapter error database DBCA fails


ora 12560 tns protocol adapter error database DBCA fails

-------------------Most common reasons for ORA-12560 in Windows are----------------------------

- firewall (port 1521)
- DHCP and not using loopback adapter
- antivirus
-Windows Domain Control should not be installed(Oracle recommends to NOT install it on a domain controller.)
-There was no ORA_DBA group and no ORADBA user on the server




while creating database in oracle 11.2.0.1 using DBCA i am getting following error.

ora 12560 tns protocol adapter error

i am using administrator userid . any soultion for this

1)
It seems you use windows OS so go %ORACLE_HOME%\network\admin directory and edit sqlnet.ora then change/add context below text
SQLNET.AUTHENTICATION_SERVICES = (NTS)

same error

2) Don't Install from mstsc
Did you try creating database through remote or directly server? if remote then try it from directly server.


i tried directly from server. oracle database software installed successfully. After that database creation i am getting this error. After getting ora 12560 tns protocol adapter error
i added tnsnames through NETCA. After that i started dbca i am getting same error. Then i checked tnsnames.ora file the entry i added NETCA is not there in the file.please provide any solution

3)

Are there only one ORACLE_HOME?
Post there sqlnet.ora file context.
Did you get other error messages than ora 12560?

Only ione oracle_home is there.Other than ora 12560 i am not getting any error. The sqlnet.ora file is given below

# sqlnet.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)



4)

refer alert.log(C:\Oracle\product\11.2.0\diag\rdbms\<sid>\<db_unique_name>\trace directory)

In trace file i am getting following error in the OraVSSW file.
Could not execute [C:\Oracle\product\11.2.0\dbhome_1\bin\OraVSSW.exe ORAWH /d]; error 1


In this location no file is generated C:\Oracle\diag\rdbms


5)
ORA-12560 running DBCA on Windows 2008 AD Controller [ID 729774.1]


Another Solution:
Install the Oracle Software on a Non-Controller machine.
You can demote the Controller machine to a Member machine.
Perform the install, create the database.
Once everything is installed and setup, you can promote the machine to a Controller.
Be aware, you may have to go through these sames steps if you want to create another Database.


6) ORA-12560 - Database Creation Assistant (DBCA) Fails With TNS Error [ID 747243.1]

Cause
There was no ORA_DBA group and no ORADBA user on the server
System policies removed the group and/or the user used to install Oracl

Solution
After creating the group/user account (by matching the ones on the current production server), the DBCA ran to completion and created the database successfully.

Check with the sys admins to see if there is a policy or process in place to remove certain users and groups.  The ORA_DBA group and the Oracle user used for the installation must remain intact.

If the problem remains, after creating the group/user account, you might need to remove Oracle and reinstall the software.

No comments:

Post a Comment

Followers