| New install of 9i, unable to login [message #185976] |
Fri, 04 August 2006 10:27  |
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 #185987 is a reply to message #185979] |
Fri, 04 August 2006 12:21  |
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 #186393 is a reply to message #186027] |
Mon, 07 August 2006 15:29 |
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 #186399 is a reply to message #186395] |
Mon, 07 August 2006 15:56 |
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 #186583 is a reply to message #186437] |
Tue, 08 August 2006 10:43 |
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 |
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 #186720 is a reply to message #186637] |
Wed, 09 August 2006 04:11 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
