This content has been marked as final. Show 6 replies
OK, I added a host and bridge socket and now I can ssh into the vm.
I still cannot install emacs or RCS. Apparently I don't need to install openssh.
OK, so I run oracle developer and I try to connect and specify username and password = oracle, hostname=127.0.0.1, port=1521, sid=orcl.
I try OS Authentication and that does not help. I keep getting
Status: Failure - Test failed: ORA-01017: invalid username/password; login denied.
I thought the documentation said all the usernames and passwords are "oracle".
Edited by: user8816970 on Sep 16, 2012 2:16 PM
There is no "oracle" account native to the database itself. This is just the default account that owns the application. Log on as oracle/oracle to the OS. (OEL) You can change the passwords of the sys and system account by setting your $ORACLE_HOME and $ORACLE_SID. Default SID is orcl on a database install. Also set a path to the oracle binaries in the form of $ORACLE_HOME/bin.
Then sqlplus / as sysdba
Change passwords of sys and system using the following example.
ALTER USER SYS IDENTIFIED BY [password];
ALTER USER SYSTEM IDENTIFIED BY [password];
The supplied appliance runs oracle enterpirse linux. Not debain or fedora.
Why do you need "emacs"?
I haven't personally load this appliance with Virtual Box but there has to be a readme file somewhere that details all the passwords and etc.
OK, I found a document in $HOME and it said all passwords where oracle.
So I tried your advice confirmed the environment variables were set and started up sqlplus.
I could not log in to SYSDBA or sysdba or SYS or sys with the password oracle.
Can someone help me get started?
Now what do you recommend for accounts if I am just using this for tutorials? Should I create my own account or use sysdba for everything?
If you have you variables set right.... then you don't need a password to do sqlplus / as sysdba
The command will connect the $ORACLE_HOME and $ORACLE_SID of the values set. This will not challenge you for a password. You will still have sysdba privileges. You can then change the passwords to whatever you want to set them to using the commands I gave you.
Yahoo! I thought that was a typo but I it is not. That is weird syntax for sqlplus to log in as sysdba.
OK, I still don't know how to install emacs but I suppose that is not important (yet).
Do you recommend I just use sysdba or create another account for creating databases and running queries to run thru some tutorials?
You have to have sysdba privileges to create databases using sql. If you're going to create more databases. I recommend using dbca.
You should create another account/schema to buildout whatever you want to build. Grant that account the minimum necessary privileges need to accomplish whatever you want to accomplish.