Oracle 11g windows server 2008

Hi,

I am trying to connect to a machine where oracle got installed by some admin person.

But I am not seeing any OracleService<oracle_sid> in services.msc services to start the service.
Can you please let me know how can  how to enable to oracleservice<oracle_sid> in services.msc? (I do not know the service name given by the admin).

This machine is new and Windows Server 2008 R2 Standard (64 bit) operating system.
Getting the below error when I try to connect as
sqlplus / as sysdba at command prompt.
ERROR:
ORA-12560: TNS:protocol adapter error

Thanks.
GouthamAnandAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
The relevant Oracle service is like

OracleServiceDBNAME

and you have to get the Windows Admin login for administering Oracle DB.
HuaMin ChenProblem resolverCommented:
To your error, are you able to ping the IP of the Oracle DB server?
slightwv (䄆 Netminder) Commented:
When the admin installed the software, id they build a database?

If you don't see the Service, then there isn't a database running.

While logged in as a local admin:  Run the Database Configuration Service and create a database.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

GouthamAnandAuthor Commented:
@slightwv,
I directly logged into that machine as Windows Admin. Can you please let me know how to run the database configuration service and to create a database. or should I approach them only to do this?

@HuaMinChen, I think I don't need to ping the oracle DB server as I logged in that machine. Also don't know the dbname given by the oracle admin.

Thanks.
slightwv (䄆 Netminder) Commented:
>>Can you please let me know how to run the database configuration service and to create a database

Look for the Database Configuration Assistant under -Program Files -> Oracle -> Assistants.

There are a LOT of settings you need to know how to set before you create the database.  Correct memory settings are probably the most important.  Correct disk setup and file locations are a close second.  Many others like proper block size, character sets, etc...

Before you ask:  No we cannot tell you what settings to use.  We do not know the requirements of the system or the server configurations.

Oracle isn't the type of system where you run setup.exe, click next 100 times and you are up and running.  Well, you 'can' do that but your system will likely not perform up to expectations.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GouthamAnandAuthor Commented:
Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.