Help
i need oracle for my practicals. i have XP. there is no problem during installation of oracle, but when i open SQLPLUS, i m prompted for username/password. i have tried SCOTT, TIGER; SYSTEM, MANAGER; INTERNAL, ORACLE. but it still gives me some TNP protocol adapter error (something like tht).
some of my friendz told me tht it works only on Win 98. but when i tried running on Win98(dual boot) i got the same error.
PLEASE HELP!!!
Page 1 of 1
oracle 8i/9i not woring on XP
#1
rohit_diwakar 
- stranger
- Group: Members
- Posts: 6
- Joined: 08-February 05
Posted 08 February 2005 - 08:55 AM
#2
rohit_diwakar
- stranger
- Group: Members
- Posts: 6
- Joined: 08-February 05
Posted 08 February 2005 - 11:07 AM
yes, before installing, oracle i installed oracle client 8 as well. in fact my installation mode was set to TYPICAL SETTINGS(this includes Oracle client automatically).
ps: i have installed sql plus on other systems (for my friends) following the same procedure. it works on their system (using SCOTT; TIGER), doesnt work on mine. itried installation on both win98 as well as XP.
ps: i have installed sql plus on other systems (for my friends) following the same procedure. it works on their system (using SCOTT; TIGER), doesnt work on mine. itried installation on both win98 as well as XP.
#3
rohit_diwakar
- stranger
- Group: Members
- Posts: 6
- Joined: 08-February 05
Posted 09 February 2005 - 10:17 AM
i tried a new installation on win98.
this time, when i used SCOTT; TIGER, i got a dialog box saying "Connectiing to database", then theres a pause and then it reads "CANNOT MOUNT DATABASE()" the workarea reads"ORACLE NOT AVAILABLE"
WHT DO I DO?
this time, when i used SCOTT; TIGER, i got a dialog box saying "Connectiing to database", then theres a pause and then it reads "CANNOT MOUNT DATABASE()" the workarea reads"ORACLE NOT AVAILABLE"
WHT DO I DO?
#4
ScinteX
- enthusiast
- Group: Members
- Posts: 317
- Joined: 23-August 04
Posted 10 February 2005 - 08:25 PM
Did someone say DBA?! 
So what version of Oracle are you using -8i?
If you can post the version (probably gonna be 8i, 9i or maybe 10g) then that would help a bit. Also the ORA error you are getting. Typically this is ORA-XXXXX where the Xs are a number.
For the TNS error I think you are getting, you need to set the following below. Before you do this you could try verifying what things look like so just type "set" at a command prompt to see if HOME or SID appear.
(open up a command prompt)
set ORACLE_HOME=<drive:path of your Oracle Home>
set ORACLE_SID=<your SID name>
Then do this (some CD'ing might be required here)
C:\oracle\oraXX\bin>sqlplus /nolog
SQL> connect /as sysdba
Hopefully you can connect!. N.b.- XX is the version number specific to your install. The SID should appear as an Oracle service. The HOME should be something like "C:\Oracle\OraXX"
Let us know if it cr@ps out on you
Good luck
S
So what version of Oracle are you using -8i?
If you can post the version (probably gonna be 8i, 9i or maybe 10g) then that would help a bit. Also the ORA error you are getting. Typically this is ORA-XXXXX where the Xs are a number.
For the TNS error I think you are getting, you need to set the following below. Before you do this you could try verifying what things look like so just type "set" at a command prompt to see if HOME or SID appear.
(open up a command prompt)
set ORACLE_HOME=<drive:path of your Oracle Home>
set ORACLE_SID=<your SID name>
Then do this (some CD'ing might be required here)
C:\oracle\oraXX\bin>sqlplus /nolog
SQL> connect /as sysdba
Hopefully you can connect!. N.b.- XX is the version number specific to your install. The SID should appear as an Oracle service. The HOME should be something like "C:\Oracle\OraXX"
Let us know if it cr@ps out on you
Good luck
S
Share this topic:
Page 1 of 1