Solved

11g On Windows 7

Posted on 2012-04-03
4
687 Views
Last Modified: 2012-04-03
I've just installed 11g on Windows 7.  I want to go into SQLPlus and do a few things but I'm getting ORA-12560 tns:PROTOCOL ADAPTER ERROR.  I look in services and see listener is automatic and running.  From the command line i try lsnrctl command and get message TNS-01190 The user is not authorized to execute the requested listener command.  
I'm in an administrator account.  Is there something else i should be a member of in Windows?
0
Comment
Question by:xoxomos
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37803235
>>ORA-12560 tns:PROTOCOL ADAPTER ERROR

This is normally because the databsae service is not running not because of the listener.

>>From the command line i try lsnrctl command and get message TNS-01190 The user is not authorized to execute the requested listener command.  

Local admin or domain admin?  Oracle really doens't like Domain Admin accounts.
0
 

Author Comment

by:xoxomos
ID: 37803278
True the database service is not running.  I'm wanting to go into SQLPlus from command prompt and startup mount.  No, it's not a domain admin.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 37803290
In Windows, the Windows service has to be running.  A running service does not mean the database is started.

Starting the service wilstart thehe database.
0
 

Author Comment

by:xoxomos
ID: 37803398
Ok, gotit.  Start up the service, then go into SQLPlus, shutdown the database and startup mount :-) :-)
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 34 99
Problem with duplicate records in Oracle query 16 29
Import and exporting Oracle Data with encrypted columns 4 29
Oracle collections 15 23
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question