If you log in as a user with the ORA_DBA group, you will be able to get into your instance without a password. Usually the user on your machine that installed Oracle will work.
Just do this at a command prompt (after setting ORACLE_HOME and ORACLE_SID)
sqlplus "/ as sysdba"
Once you've done that, you can "alter user sys identified by xxxxx" to change the SYS password (replace xxxxx with the new one) .
Faced the problem listener was not starting because it did not have access to the log file for writing.
Exported the following variable at command line
$ export ORACLE_HOME
$ export PATH=$ORACLE_HOME/bin:$PATH
$ /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/lsnrctl status
TNS:net service name is incorrectly specified
Went to ORACLE_HOME above /network.admin/tnsnames.ora to find out the settings.
user - The login user name defined in the Oracle server.
password - The password for the login user.
host - The host name where Oracle server is running.
Default is 127.0.0.1 - the IP address of localhost.
port - The port number where Oracle is listening for connection.
Default is 1521.
SID - System ID of the Oracle server database instance.
SID is a required value. By default, Oracle Database 10g Express
Edition creates one database instance called XE.
Return machine Id and use this for routing future requests . This will give cache locality. The ui/ mobile app should use this I'd f...
Question: Which of the following best describes a sprint? The correct answer was: A sprint is a condensed amount of time in which a devel...
Recently i was faced with a scenario where user would select a few files from a list and click download. All the downloads should start in...
The home directory does not exist or is missing a required file or folder: modules\org\jboss\as\server\mainThe home directory does not exist or is missing a required file or folder: modules\org\jboss\as\server\main To Solve this problem 1) As sh...