I have an issue with Oracle Express 11g in windows7 32bit. Everytime when I try to conncet to the database I get this error message. How can I fix it please!
Oracle Express 11g
1 Answer 1
You most likely need to set the ORACLE_SID environment variable. This error usually means you are trying to connect to a database that doesn't exist. Also check that ORACLE_HOME is set correctly. If that doesn't fix it, check if the database service is started. If it is, check the alert log for error messages.
answered Mar 24, 2014 at 11:34
-
How Can I do this ? (exuse me Im a begginer)Mohsenuss91– Mohsenuss912014年03月24日 15:25:03 +00:00Commented Mar 24, 2014 at 15:25
-
Follow step 5 here to make sure the DB is started: docs.oracle.com/cd/E17781_01/install.112/e18803/…Andrew Brennan– Andrew Brennan2014年03月24日 15:39:52 +00:00Commented Mar 24, 2014 at 15:39
-
unfortunately, I get the error message when I use SYSTEM and my password to connect.Mohsenuss91– Mohsenuss912014年03月24日 22:22:48 +00:00Commented Mar 24, 2014 at 22:22
-
Did you start the database using Step 5.1 in the above document? Did you get any error messages when you did that, or during the installation?Andrew Brennan– Andrew Brennan2014年03月25日 09:58:09 +00:00Commented Mar 25, 2014 at 9:58
-
Yes, the DB is started but when I put "connect System" & the password in the sqlplus cmd line I get this error message i.sstatic.net/rsehS.jpg and even when I use this andress 127.0.0.1:8080/apex/f?p=4950 I can't connectMohsenuss91– Mohsenuss912014年03月25日 15:49:39 +00:00Commented Mar 25, 2014 at 15:49
lang-sql