Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 1st, 2004, 06:54 AM
poppy_123 poppy_123 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 91 poppy_123 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 54 sec
Reputation Power: 5
oracle username,password

i have installed newly version of oracle9i, when i open the sqlplus editor, and give username and pass as
username=scott
password=tiger

it gives error as "PROTOCOL ADAPTOR ERROR"
if i give hoststring
host string=localhost

it says, "could not resolve service name"

Reply With Quote
  #2  
Old April 1st, 2004, 09:03 AM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 6
This error occures when your service is stop, plz start your service. If you dont have any service to connect wuth database, create new one.

Reply With Quote
  #3  
Old April 1st, 2004, 04:10 PM
poppy_123 poppy_123 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2003
Posts: 91 poppy_123 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 54 sec
Reputation Power: 5
yes i have start my service, can u mention which service should run must, i have 7 services running, at a time.
and does username and password are correct, is there any need for host string as well , i am using it in personal pc.
I installed it not as server application but custom.

Reply With Quote
  #4  
Old April 15th, 2004, 03:04 AM
guy_manpreet guy_manpreet is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 8 guy_manpreet User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
how to create the service ? culd plz explain a bit

Reply With Quote
  #5  
Old April 15th, 2004, 10:16 AM
shafique shafique is offline
Senior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Canada
Posts: 305 shafique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 20 sec
Reputation Power: 6
To create a new service, you can use the one of the following method

Method 1:
---------
go to the oracle_home\network\admin and add the following commands in "tnsnames.ora" file, for example my database name is 'PROD' and my computer name is 'mycomputer':

PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mycomputer (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod.world.com)
)
)

Method 2:
---------
Oracle also provides graphical interface such as for Oracle8i 'SQL net easy configuration' or 'Net8 easy config' utility, for Oracle9i, i think you have to use 'Oracle Net Manager'

Regards,

Reply With Quote
  #6  
Old December 4th, 2005, 03:39 AM
Jeea Jeea is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2005
Posts: 1 Jeea User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 29 m 37 sec
Reputation Power: 0
I need URGENT help

I had the exact same problem as poppy 123 did.
i need full detail as to wat service shud b open n abt your last reply for the net configuration thing, i hav that file, but it's not working. where is tnsnames.ora? i need explanation to everything that u hav explained to poppy 123. (Sorry, i'm a newby ).
By the way, i'm doing all my work on Win XP.
The default username is 'scott', password is 'tiger' and hoststring is empty rite? on the home pc?
Please i need to practice on Developer Form 6i. So do reply soon. My finals are in the end of December. I need urgent help in this matter.

Last edited by Jeea : December 4th, 2005 at 03:48 AM. Reason: Missing Text

Reply With Quote
  #7  
Old December 28th, 2005, 01:13 PM
emotional_robot emotional_robot is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 53 emotional_robot User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 19 h 40 m 35 sec
Reputation Power: 5
Send a message via Yahoo to emotional_robot
Smile

Do a search for *.ora in ur system..those are not a large number of files..
listener.ora
tnsnames.ora
init.ora
and there will be some more....the number of these files
will increase one by one as u will be adding the databases
one by one...
there will be one initORACLE_SID.ora for each oracle_sid(database)..

Read those files ...
you will definitely get a lot of idea...
bye.........

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > oracle username,password


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT