Home » RDBMS Server » Server Administration » Oracle 11g Installation (Windows 2008 64 bit enterprise)
Oracle 11g Installation [message #437383] Mon, 04 January 2010 03:25 Go to next message
royalrodrigues
Messages: 4
Registered: May 2008
Junior Member
Dear team,

I have installed Windows 2008 64 bit enterprise edition and Oracle 11g 64 bit edition. Now When I start the oracle database server service fro service.msc windows, it's working fine. But same if I start in command prompt (CMD) mode with below mention commands

c:\sqlplus /nolog
SQL>conn sys/pass@oratest as sysdba

I am getting below error

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I have attached the error for your kind perusal.Kindly give me solution on same

Thanks and Regards
Royal Rodrigues

Re: Oracle 11g Installation [message #437389 is a reply to message #437383] Mon, 04 January 2010 03:43 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
ORA-12514

It is a FAQ.
Please search before posting.

sriram Smile
Re: Oracle 11g Installation [message #437392 is a reply to message #437383] Mon, 04 January 2010 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: Oracle 11g Installation [message #437888 is a reply to message #437389] Wed, 06 January 2010 06:14 Go to previous messageGo to next message
royalrodrigues
Messages: 4
Registered: May 2008
Junior Member
Thanks Michel,

I able to do tnsping to my database. But with lsnrctl services listener.ora command I am getting below error


TNS-01101: Could not find service name

Should I have made any entry in listener.ora file?? Please suggest?
Re: Oracle 11g Installation [message #437889 is a reply to message #437888] Wed, 06 January 2010 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Too few information to compute.

Post all what you did (that is copy and paste), specify if it is from server or client.
Post all environment variables.

Regards
Michel
Re: Oracle 11g Installation [message #437896 is a reply to message #437888] Wed, 06 January 2010 07:11 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Based on the info....i can suggest this..

Quote:
Oracle Error :: TNS-01101
Could not find service name string

Cause
The ervice name could not be resolved by name-lookup.

Action
Verify that the listener name or service name specified to LSNRCTL has the correct name and address defined in LISTENER.ORA or in TNSNAMES.ORA.



sriram Smile
Re: Oracle 11g Installation [message #439110 is a reply to message #437383] Thu, 14 January 2010 05:27 Go to previous messageGo to next message
dibakar
Messages: 4
Registered: December 2009
Location: kolkata
Junior Member
please update tnsname.ora file in the oracle_home.edit via vi tnsname.ora.

edit like that in tnsname.ora-->
DEV12D2B =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 157.227.221.57)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEV12D2B)
)
)
-----------------

then i think your problem will be solved
Re: Oracle 11g Installation [message #439113 is a reply to message #439110] Thu, 14 January 2010 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Where did you find that OP's service name is DEV12D2B?
Or that an entry named DEV12D2B will help hin in any way?
Or that his host IP is 157.227.221.57?
Or that his listener is listening on 1521 port?

By the way, thanks to post your server IP, now I can hack your database.

Regards
Michel
Re: Oracle 11g Installation [message #439115 is a reply to message #439113] Thu, 14 January 2010 06:33 Go to previous messageGo to next message
dibakar
Messages: 4
Registered: December 2009
Location: kolkata
Junior Member
no don't do this....
DEV12D2B--database name
ip address is your system ip .
1521 is same.
Re: Oracle 11g Installation [message #439121 is a reply to message #439115] Thu, 14 January 2010 07:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
1521 is same.

Why? We have about 1600 databases and none of the listeners are using port 1521.

Regards
Michel
Re: Oracle 11g Installation [message #439124 is a reply to message #439110] Thu, 14 January 2010 07:59 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
dibakar wrote on Thu, 14 January 2010 06:27
please update tnsname.ora file in the oracle_home.edit via vi tnsname.ora.

edit like that in tnsname.ora-->
DEV12D2B =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 157.227.221.57)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEV12D2B)
)
)
-----------------

then i think your problem will be solved


Why would you post such information in a public forum? I do not think your security team would be too happy with you.
Re: Oracle 11g Installation [message #439205 is a reply to message #439124] Thu, 14 January 2010 21:52 Go to previous message
royalrodrigues
Messages: 4
Registered: May 2008
Junior Member
Dear all,

I have resolve my problem. I have made changes in listener.ora and now I am not getting the same error.

Thanks to all for your support and cooperation.


Regards
Royal Rodrigues
Previous Topic: Performance degrade while deleting 1 million row
Next Topic: Kill back end session & Time taken to kill session (merged)
Goto Forum:
  


Current Time: Fri Nov 29 11:40:19 CST 2024