Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Course Of The Month
9 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
LOG ON To Oracle and PLSQL
Posted on 2006-06-10
Hi,
I just installed ORACLE DB on my system (win XP). After all instalation i want to log in to DB, create new DB, logIn to PLSQL to start quering but every time user name and pass are wrong!!!
I can swear that i input admin:admin so it will be easy for me but cannot!
Can someone pls explain me simply what to do so i can logIn
another think, what is NET SERVICE NAME i have to input and in the PLSQL Host String.
GOD i just want to connect, why so complicated? why not like MSSQL??!!
Thank you
I just installed ORACLE DB on my system (win XP). After all instalation i want to log in to DB, create new DB, logIn to PLSQL to start quering but every time user name and pass are wrong!!!
I can swear that i input admin:admin so it will be easy for me but cannot!
Can someone pls explain me simply what to do so i can logIn
another think, what is NET SERVICE NAME i have to input and in the PLSQL Host String.
GOD i just want to connect, why so complicated? why not like MSSQL??!!
Thank you
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
4- +2
16 Comments
Active 1 day ago
gilboker,
> what to do so i can logIn
by default the username/password for the Oracle will be scott/tiger
> what to do so i can logIn
by default the username/password for the Oracle will be scott/tiger
>I just installed ORACLE DB
what version? I assume on windows environment?
did you install only the software, or did you indeed create the starter db from the setup?
What database SID did you give the oracle database? if you don't know, check in the Windows Services Applet, you will find some
>another think, what is NET SERVICE NAME i have to input and in the PLSQL Host String.
use the <SID> value from above when connecting locally
>GOD i just want to connect, why so complicated? why not like MSSQL??!!
well, Oracle is a product that is "older", ie more evaluated, more functionality, more configurations possible.
indeed, mssql is more like "install and done", but Oracle is not that way.
That's why a MSSQL MCDBA Certificate is quite easy to get, but Oracle full OCP path is very difficult.
Also, a true Oracle DBA has MUCH higher skills (and salary) than MSSQL DBA.
I assume you try to connect with SQL*Plus or what?
what version? I assume on windows environment?
did you install only the software, or did you indeed create the starter db from the setup?
What database SID did you give the oracle database? if you don't know, check in the Windows Services Applet, you will find some
>another think, what is NET SERVICE NAME i have to input and in the PLSQL Host String.
use the <SID> value from above when connecting locally
>GOD i just want to connect, why so complicated? why not like MSSQL??!!
well, Oracle is a product that is "older", ie more evaluated, more functionality, more configurations possible.
indeed, mssql is more like "install and done", but Oracle is not that way.
That's why a MSSQL MCDBA Certificate is quite easy to get, but Oracle full OCP path is very difficult.
Also, a true Oracle DBA has MUCH higher skills (and salary) than MSSQL DBA.
I assume you try to connect with SQL*Plus or what?
Angel
yes i installed Orcale 10g enterprise!
My DB name is default orcl
i cant input my user name and password when try to connect in sqlPlus or in administration assistant.
I just installed it , didnot make any new database yet!!!
Is ther a way to retrive it?
yes i installed Orcale 10g enterprise!
My DB name is default orcl
i cant input my user name and password when try to connect in sqlPlus or in administration assistant.
I just installed it , didnot make any new database yet!!!
Is ther a way to retrive it?
from a command line type "sqlplus" and tell us what it says (normally it should ask you for a username and password but you said it isnt even getting to that point)
from command line/windows sqlsplus:
sqlplus admin/admin@orcl
or, from command line
SET ORACLE_SID=ORCL
sqlplus admin/admin
sqlplus admin/admin@orcl
or, from command line
SET ORACLE_SID=ORCL
sqlplus admin/admin
Its funny
This morning i made a new database and gave him pass admin. it was fine but now again i can logIn!!!
This morning i made a new database and gave him pass admin. it was fine but now again i can logIn!!!
i bet that the problem is that the database is not started or the listener is not started.
to make sure the database is started, open the orcl admin page (a link in your start menu) and click the button that says startup database if it says it is down (it will show this before asking you for any user/password if it is down)
if the database is started then run this from a command line:
lsnrctl start LISTENER
if it still doesnt work your going to have to give me the info i requested (what it says when you type "sqlplus" on a command prompt)
to make sure the database is started, open the orcl admin page (a link in your start menu) and click the button that says startup database if it says it is down (it will show this before asking you for any user/password if it is down)
if the database is started then run this from a command line:
lsnrctl start LISTENER
if it still doesnt work your going to have to give me the info i requested (what it says when you type "sqlplus" on a command prompt)
Please check your database and listener.
to check :
Click Start -> Control Panel -> Administrative Tools -> Double click Services.
Scroll down and find
OracleOraDb10g_home1TNSLis
OracleServiceORCL
and check the status whether they are started or not. If not, you can start the service here.
If all services are started, and if you still can't login, please tell me what sort of error message that you get.
You probably need to configure using Net Configuration Assistant.
Pls try this first.
to check :
Click Start -> Control Panel -> Administrative Tools -> Double click Services.
Scroll down and find
OracleOraDb10g_home1TNSLis
OracleServiceORCL
and check the status whether they are started or not. If not, you can start the service here.
If all services are started, and if you still can't login, please tell me what sort of error message that you get.
You probably need to configure using Net Configuration Assistant.
Pls try this first.
kg1973
Hi , I get errot "LISTENER DOES NOT CURRENTLY KNOW OF SERVICE REQUESTED IN CONNNECT"
for the othre DB i just get user name and password not known
Hi , I get errot "LISTENER DOES NOT CURRENTLY KNOW OF SERVICE REQUESTED IN CONNNECT"
for the othre DB i just get user name and password not known
Have you started the listener and database services ?
Have you ever configure using Net Configuration Assistant after you installed the database ?
Is your machine connected to any network during the installation ?
Have you ever configure using Net Configuration Assistant after you installed the database ?
Is your machine connected to any network during the installation ?
Have you started the listener and database services ? YES
Have you ever configure using Net Configuration Assistant after you installed the database ? NO
Is your machine connected to any network during the installation ? NO
I think i will try to reinstall all!
Funny i was ok yesterday but today machine says DB Locked.
Have you ever configure using Net Configuration Assistant after you installed the database ? NO
Is your machine connected to any network during the installation ? NO
I think i will try to reinstall all!
Funny i was ok yesterday but today machine says DB Locked.
If you reinstall, please take note your service name, ie, by default ORCL.
Since you are not connected to any network, it will use your default ip address 127.0.0.1
Also take note of your system password -- you need this for testing the connection during configuration
When you finished reinstallation, pls quickly check the status of your listener and database services ?
By default it will start automatically. If they are ON, you can only login after you finish configuration.
To configure (assuming all services started) :-
Click Start All programs-> Oracle OraDb10g - home2
-> Configuration and migration tools
-> Net configuration assistant
-> select Local Net Service Name Configuration
-> select Add
-> service name : ORCL -- the one you entered during the installation
-> select tcp
-> hostname : 127.0.0.1 or your computername
-> Yes, perform test
-> Reenter new password that you assigned during the installation
-> done.
Then you can login using sqlplus.
Since you are not connected to any network, it will use your default ip address 127.0.0.1
Also take note of your system password -- you need this for testing the connection during configuration
When you finished reinstallation, pls quickly check the status of your listener and database services ?
By default it will start automatically. If they are ON, you can only login after you finish configuration.
To configure (assuming all services started) :-
Click Start All programs-> Oracle OraDb10g - home2
-> Configuration and migration tools
-> Net configuration assistant
-> select Local Net Service Name Configuration
-> select Add
-> service name : ORCL -- the one you entered during the installation
-> select tcp
-> hostname : 127.0.0.1 or your computername
-> Yes, perform test
-> Reenter new password that you assigned during the installation
-> done.
Then you can login using sqlplus.
KG1973
Thank you for all the info. I just created a new DB call TEST with User name and pass i can remember for testing.
Last question, Can i add tables like in MSSQL? or i have to create PLSQL statment to create them for me so i can see them in tree view in Administration assistant?
Points go to you mate!
:)
Thx
Thank you for all the info. I just created a new DB call TEST with User name and pass i can remember for testing.
Last question, Can i add tables like in MSSQL? or i have to create PLSQL statment to create them for me so i can see them in tree view in Administration assistant?
Points go to you mate!
:)
Thx
I am glad to hear that :-)
Last question, Can i add tables like in MSSQL? or i have to create PLSQL statment to create them for me so i can see them in tree view in Administration assistant?
Yes you can. You can use sql command to create or add tables.
OR If you are dba/administrator, you can use Oracle Enterprise Manager to manage your database.
A lot of things can be done with this tools.
This OEM is a separate service that need to be started similar with your DB. ( this might slow down your pc )
check the status (services) and scroll down -OracleDBConsoleTEST and start the service.
Once the service is started, Run Internet Explorer and type this http:\\127.0.0.1:5500\em OR http:\\yourcomputername:5500\em
You need to login as system/password/normal
Once you are in, click Administration tab... there you go
If you don't know anything, just click help... its really help you...
Good luck.
Last question, Can i add tables like in MSSQL? or i have to create PLSQL statment to create them for me so i can see them in tree view in Administration assistant?
Yes you can. You can use sql command to create or add tables.
OR If you are dba/administrator, you can use Oracle Enterprise Manager to manage your database.
A lot of things can be done with this tools.
This OEM is a separate service that need to be started similar with your DB. ( this might slow down your pc )
check the status (services) and scroll down -OracleDBConsoleTEST and start the service.
Once the service is started, Run Internet Explorer and type this http:\\127.0.0.1:5500\em OR http:\\yourcomputername:5500\em
You need to login as system/password/normal
Once you are in, click Administration tab... there you go
If you don't know anything, just click help... its really help you...
Good luck.
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
- Superb Internet
- IT Administration
- Ransomware
- Storage Software
- Databases
- Cloud Computing, Cloud Services, *Backups, *Online Backup Services, *Backup Software
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month9 days, 23 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.