Firewall isn't relevant when using loopback (127.0.0.1) IP address.switch off the windows firewall
Step Two, make sure your listener is running, back to the command box:
sqlplus /nolog connect system ... password: <use the one set in the install> ... Connected. -- Or ... maybe not. Try starting it: conn /as sysdba; ... Connected to idle instance ... startup;
Step Three, check that `lsnrctl status` command output, you should have two endpoints, the database default 1521 port, and the 8080 web page port. If the 8080 port isn't in the lsnrctl output, the web pages will not work.
lsnrctl status ... Endpoints: ... 1521 ... ... http ... 8080 ...
"seems like" and "actually are" could be two very different things, connecting to the database to ensure it is running and the lsnrctl status command are ways to check and verify.it seems like everything is up and running
Actually a static IP is preferred for a server- don't want it to have a different IP every time it boots as can happen with DHCP.my computer has a static IP address
When changing a listener.ora setting be sure the listener is not running, the HOST= tells lsnrctl what address to talk to for controlling the listener.
lsnrctl stop ... notepad <drive: ... >\network\admin\listener.ora ... change: HOST=BERNIE ... to: HOST=0.0.0.0 ... save and exit, start the listener lsnrctl start ... connect to the database and force it to register sqlplus /nolog connect system ... password ... Connected. alter system register; ... exit ... check listener status again lsnrctl stat
Maybe. If desktop admin task skills are elusive, maybe not. MS Sqlserver express edition is another "free" database option, it has several prerequisites that the installer usually gets loaded to the desktop OK, if you have admin rights on the desktop.maybe my SQL will make it easier for me ?
Everything? Stopping the listener, moving/renaming the listener.ora file is not that hard to do.I tried everything without any luck