Oracle x Domain Server 2008

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
marochavieira
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Wed, 12 May 2010 10:08 am
Location: Jataí - GO

Good morning to all

I do not understand practically anything Oracle, but in the company I work, the BD is in Oracle and we are migrating the Server 2003 to 2008.

I migrated and now I have the following problem, I installed the server, I put as the domain controller all beautiful, later I installed Oracle all in conforming, but when I will ride the base he gives me the following message: ORA-12560: TNS: Protocol adapter error

given this error .. Do not let the creation of BD Oracle.

In Server 2003 this problem does not happen.

Then I did the following test .. on another machine .. I put the 2008 server, I installed Oracle and tried to create the BD .. created normal, but, as a precise domain, after creating The BD Oracle on the same machine, I went to put it as a domain controller, I put it and later I tried to create another base in Oracle, behold, it gave the same mistake.

So the problem is this .. this Incompatibility of Oracle with the domain.

Ahh .. To Using Oracle 10.2.0.4

Can anyone help me?

Thank you very much.

Thanks

Marco Aurelio
User avatar
dr_gori
Moderador
Moderador
Posts: 5027
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Topic Moved for DBA
CarlosStetner
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 16
Joined: Fri, 14 May 2010 8:06 pm
Location: São José dos Campos - SP
O Primeiro passo não vale nada se você não chegar ao final.

I do not have much contact with windows, but let's see if I can give a light !!

This is a very generic mistake, so it's complicated to tell you what will solve.

I imagine that has changed the name of the server and the right IP?
If yes, look at these files, $ oracle_home / rdbms / network / admin / tnsnames.ora and listener.ora These 2 files usually have server or IP name, then you need to correct them.
If you know what Listener is, you need to restart them, there must be a service called lsnr_nomebanco, a restart on it and see if it solves.

If this does not solve.

Please pass more details on how you are doing to migrate the bank from one server to the other.
RJG
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 79
Joined: Tue, 16 May 2006 11:40 am
Location: Patos de Minas - MG

Is happening the same with me !!
bad because you do not think anything about Oracle x 2008 Server !!
of the protocol adapter error !!!!
elidias7
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 153
Joined: Thu, 01 Nov 2007 2:53 pm
Location: Osasco
Eli Dias
Oracle Certified Professional

Oops!
explains something I did not understand ............

You are with the server in Domino right, then you can not create a base of Data, or do you normally create it and when you try to connect it presents this message?

or

You are with the bank created but when you try to connect it brings you this message ??
If this is, where are you trying to make the connection with the bank?

(SQLPlus / SYSDBA)
or
(SQLPLUS USER / PASSWORD @ NOMEDOBANCO)

The listener is in the air ?
Enterprise Manager has been configured, if yes, it works ??

Even you do not understand anything are simple questions to check, but see this and send back to Forum ..........

Hugs,
RJG
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 79
Joined: Tue, 16 May 2006 11:40 am
Location: Patos de Minas - MG

Version: Oracle 10g or 11g
OS: 2003 Server R2 virtualized within 2008 R2 !!!
of the same error installing in 2008 or 2003 !!
From what I understand his problem is the same as mine !!
and when you create the database (that bd clone) that creates when you end up install and the installation opens the tools automatically already creating instance and database !!
The following errors:

Select all

ORA-12560: TNS:erro de adaptador de protocolo
or

Select all

ORA-03113: fim de arquivo no canal de comunicação
will be simple ????
What will you know ????
Thanks ... Abratss
elidias7
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 153
Joined: Thu, 01 Nov 2007 2:53 pm
Location: Osasco
Eli Dias
Oracle Certified Professional

Oops!

This is strange, I just did the same test as you, and it simply worked!

Only when I did not exactly what you did, at the time of installation of the software I decided to create the bank later.

I have an environment 2008 R2 here, try to do this and send the forum result

Hugs
mgonzalez
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Tue, 21 Sep 2010 12:12 pm
Location: Rio de Janeiro - RJ
M.Ganzalez
DBA - Oracle

Just to pass a little experience, whenever IP or machine name or domain name,

Select all

$ORACLE_HOME/network/admin/listner.ora
must be corrected for the correct name or IP. After corrected restart the Listener service.
Enterprise Manager should be redone in case of machine name switching.
cream3
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 17
Joined: Mon, 17 May 2010 10:49 pm
Location: Belo Horizonte

I'm spending greater roe.

In my case, my environment is as follows:
Windows 2003 virtualized and domain.
When I install Oracle "8i", it installs the tool, but at the time of the creation of DB, this protocol error.
I did to create the bank afterwards, and also the same error.
I turned on Listener, SQL.NET and TNSNAMES.
I turned on the service manager, I turned the internet from head. Nothing makes it work.
Tent Connection via Conn / Sysdba and also gives the same error.
I reinstalled about 800 times and the error blows.

One thing that caught my attention was that I installed the same Oracle in my home also in Windows 2003 virtualized environment and everything worked perfect.
I'm suspected of being the domain. It makes sense:?
But I have a same bench running in domain in production, I was trying to climb a machine in virtual to create test instances.

Urgent .... Please ..!
cream3
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 17
Joined: Mon, 17 May 2010 10:49 pm
Location: Belo Horizonte

Resolved,

problem of the machine is in domain.
was to remove the machine from domain that worked normally.
User avatar
stcoutinho
Moderador
Moderador
Posts: 850
Joined: Wed, 11 May 2011 5:15 pm
Location: são Paulo - SP

Hello,

There is a note in Metalink that may be related to the error you are facing:
Ora-12560 Running DBCA on Windows 2008 AD Controller [ID 729774.1]
This note explains that the Database Configuration Assistant (DBCA) can stick during its run in a series of Windows platforms (Vista, 2008, etc. ), both for 32 and 64 bits. In the case of 2008, especially if the machine has an Active Directory Controller. This error occurs for Oracle versions of 10.2 up to 11.1.

For the solution to this problem, the note relates a series of patchesets (correct packages), according to the release of the bank. These packages can only be obtained within Metalink.

Hugs,

Sergio Coutinho
cream3
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 17
Joined: Mon, 17 May 2010 10:49 pm
Location: Belo Horizonte

Sergio, in my case, I even posted it in a wrong place by the title, but I believe the subject related, use Oracle 8i on Win 2003 Server platform.

Half Fuck this.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest