?
Solved

help open sqlplus

Posted on 2005-02-24
8
Medium Priority
?
624 Views
Last Modified: 2012-05-05
I just download Oracle9i Database Release 2 Enterprise/Standard/Personal Edition
from oracle  web site 3 download I am trying to open sqlplus

It is ask me for

User Name ______
Password________

Host string_______

I tried to use User scott and password tiger

is there another way user and password?
0
Comment
Question by:jamesccnacmp
[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
8 Comments
 
LVL 9

Expert Comment

by:joaoalmeida
ID: 13394783

User system and password manager

0
 

Author Comment

by:jamesccnacmp
ID: 13394914
what about the host string?
0
 
LVL 9

Expert Comment

by:joaoalmeida
ID: 13394957

If it is the personal edition it would probably by 2: or blank.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Author Comment

by:jamesccnacmp
ID: 13395017
type in the number  2 or type in blank, the user and password is not allow me in?
0
 
LVL 9

Accepted Solution

by:
joaoalmeida earned 1000 total points
ID: 13395071
try


system
manager
2:

(number 2 and colon)
0
 

Author Comment

by:jamesccnacmp
ID: 13395122
No it just kick me out I type

user: system
password: manager
Host string: 2:

0
 
LVL 11

Expert Comment

by:sujit_kumar
ID: 13400157
NO, you will have to create a TNS String for your server from "Net Configuration Manager". Give your Machine's IP and the SID being ORCL (this is default, if you haven't chaged anything). Give it's name as "localHost"

No connect to OEM Using,

system/manager@localHost

Sujit
0
 
LVL 7

Expert Comment

by:Mehul Shah
ID: 13400181
Go to

Oracle Home\network\admin folder

open the tnsnames.ora file and add the below entry

<<DB_NAME> =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <<IP ADDRESS>>)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = <<DB_NAME>>)
    )
  )

Change the <<DB_NAME>> and <<IP_ADDRESS>> parameter according to your server.

and use the <<DB_NAME>> as the host string.

Hope this helps
0

Featured Post

Technology Partners: We Want Your Opinion!

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this article, we’ll look at how to deploy ProxySQL.
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…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

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