Home » SQL & PL/SQL » SQL & PL/SQL » New install of 9i, unable to login
New install of 9i, unable to login [message #185976] Fri, 04 August 2006 10:27 Go to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
Hello all.. I'm trying to set up my home computer with Oracle for an upcoming SQL class I'm taking so I can run code for homework purposes only. I can't seem to get into the SQLplus worksheet to run any code is my problem. I'm hung up on a login box that either gives me an error or closes the application. I'll give you my history first.
I've installed Oracle9i release 2 with the 3 disk set I downloaded off the Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP page.
Although I haven't installed Oracle9i Database Release 2 Client, nor the Oracle Real Application Clusters and Cluster File System. Could that be the problem, I don't know. I am a newbie here so bear with me please.

Here's a list of my products installed when I view the inventory:
Independent products; Java Runtime Env./Oracle Univesal Installer/Oracle Remote Conf. Agent/Oracle Snap-In Common Files
Oracle Homes;OraHome92/Oracle9i Database.
Under the Oracle9i Database I see "Enterprise Manager Products" and "Oracle HTTP Server" and "Oracle Net Services" as just a few of the options. Although I thought I had selected "Personal Edition" when I ran the install. On my program menu I have Integrated Management Tools, Enterprise Manager Console, Application Management Tools, and Configuration and Migration tools plus more.

My system is a Dell Optiplex GX270 running XP Pro SP2 with 11 gigs of free space and 2.4 Ghz and 1 Gig of RAM.

I've ran lsnrctl start and get a message of:
Service OracleOraHome92TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error


I try to open SQL Plus Worksheet (at least that's the first thing I assume I can do after the install is at least open it)
and on the Oracle Enterprise Manager Login I select "Connect directly to database", Username "scott", password "system", service "sys", connect as normal. And I recieve error message: ERROR:ORA-12154: TNS:could not resolve service name

If anyone can tell me what I'm doing wrong it would be appreciated.
If anything my next step would be a uninstall and then re-install.
Re: New install of 9i, unable to login [message #185979 is a reply to message #185976] Fri, 04 August 2006 11:00 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, I don't know about former steps you did, but it seems that your logon credentials are wrong.

Default database is ORCL, so you should - unless you've changed it during installation process - enter this as "service".

Default username/password combinations are:
- scott/tiger
- sys/change_on_install
- system/manager

Try to log in using one of these combinations; come back if you don't succeed.
Re: New install of 9i, unable to login [message #185987 is a reply to message #185979] Fri, 04 August 2006 12:21 Go to previous messageGo to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
Thanks for the reply Littlefoot.
I believe I created my defualt database as:
ACME.COMPANY.COM

Anyway when I login as:
scott
sys
ORCL

ERROR:ORA-12154: TNS:could not resolve service name


When I login as:
scott
sys
ACME

ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

Same error comes up with tiger,change_on_install,ACME.

When I launch the Enterprise Standalone Console I can see the network database view with the ACME.COMPANY.COM name under "Databases" if that helps.
Re: New install of 9i, unable to login [message #186027 is a reply to message #185987] Fri, 04 August 2006 16:03 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you didn't understood me ... try to connect as:

username = scott
password = tiger
database = acme -> check this value in the TNSNAMES.ORA file; it should look like this:
ACME =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora10g)
    )
  )


or

username = sys
password = change_on_install
database = acme
Re: New install of 9i, unable to login [message #186393 is a reply to message #186027] Mon, 07 August 2006 15:29 Go to previous messageGo to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
Thanks again, this time it appears I've made at least some progress. Checked the Ora file and plugged in its value and changed the way I'm signing in to your recomendations, here's my response after executing the login.

ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

Have I made any progress?
Re: New install of 9i, unable to login [message #186395 is a reply to message #186393] Mon, 07 August 2006 15:40 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does

OS> lsnrctl status

say?
Re: New install of 9i, unable to login [message #186399 is a reply to message #186395] Mon, 07 August 2006 15:56 Go to previous messageGo to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
Still at:


Starting tnslsnr: please wait...

Service OracleOraHome92TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error
Re: New install of 9i, unable to login [message #186437 is a reply to message #186399] Tue, 08 August 2006 00:04 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can you look at (Administrative Tools -> ) Services, and check Oracle services - stop listener manually and start it up again?

TNS error messages aren't (that is, doesn't seem to be) very descriptive:
Quote:

TNS-12560 TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.
Quote:

TNS-00530 Protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: For further details, turn on tracing and re-execute the operation.
Re: New install of 9i, unable to login [message #186583 is a reply to message #186437] Tue, 08 August 2006 10:43 Go to previous messageGo to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
Stopped listener in Services, then restarted but came up with the same ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process.

Here's the listener log file:

System parameter file is C:\oracle\ora92\network\admin\listener.ora
Log messages written to C:\oracle\ora92\network\log\listener.log
Trace information written to C:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0

Started with pid=1412
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=COPS-08.eagledirect.com)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
08-AUG-2006 09:27:32 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ACME)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=COPS-08)(USER=dwegelin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.11.1.5)(PORT=1912)) * establish * ACME * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
Re: New install of 9i, unable to login [message #186586 is a reply to message #186583] Tue, 08 August 2006 11:05 Go to previous messageGo to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
Here's something interesting...
http://www.lsbu.ac.uk/oracle/oracle7/net/doc/NWUS233/apc.htm

ORA-12500 TNS:listener failed to start a dedicated server process:
This message indicates that the listener was unable to start a process connecting the user to the database server. The most likely cause is that the SID_LIST section of the LISTENER.ORA file or the system identifier (SID) in the CONNECT DATA section of the TNSNAMES.ORA file is incorrect. Check each of these files.

LISTER.ORA FILE:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ACME)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = ACME)
)
)


TNSNAMES.ORA FILE:
[ (CONNECT_DATA=
(SID=<oracle_sid>)
[ (GLOBAL_NAME=<global_database_name>) ]
)
]
[ (SOURCE_ROUTE=yes) ]



Do you think I should change the (SID=<oracle_sid>)
in the TNSNAMES.ORA file to (SID=<ACME>) ??
Re: New install of 9i, unable to login [message #186624 is a reply to message #186586] Tue, 08 August 2006 15:26 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do so, just like you've seen in post #185987 in this thread.
Re: New install of 9i, unable to login [message #186637 is a reply to message #186624] Tue, 08 August 2006 16:17 Go to previous messageGo to next message
dwegelin
Messages: 7
Registered: August 2006
Location: NEWBIE
Junior Member
I tried it but no luck.

[Updated on: Tue, 08 August 2006 16:30]

Report message to a moderator

Re: New install of 9i, unable to login [message #186720 is a reply to message #186637] Wed, 09 August 2006 04:11 Go to previous message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
Hey-

Please check for 2 things and take a note of it:
1-> SID
2-> DB_NAME (Usually both SID and DB_NAME are same if you have created using DBCA)

As I think in your case it is 'ACME'

Now open your listener.ora file which would be located in ORACLE_HOME/network/admin/listener.ora

In that you comment out the existing entries, and just copy & paste the below mentioned entries

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ACME)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = ACME)
)
)


In the tnsnames.ora file your entry should be like:
ACME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ACME)
)
)

After you performed the above mentioned changes.

Restart your both listener, and service which you can do from your services option in Administrative tools..

once you have restarted it, check for the status of listener.

Thanks,
Rama.
Previous Topic: Avoiding Hardcoding folder paths
Next Topic: getting last day of the month - feedback asap pls
Goto Forum:
  


Current Time: Sun Dec 04 02:41:07 CST 2016

Total time taken to generate the page: 0.08787 seconds