Can't log to instance

[Aljaz]

Well, I've shut down my database and now I can't start it again.

I can't even connect to instance. I'm trying to do this

c:\>sqlplus /nolog
sql>connect internal/oracle

Then I get error ORA-01017 invalid username/password ; logon denied

If I try to connect as connect sys/password as sysdba
or like connect sys/password@mydb as sysdba
or like connect sys/password@mydb

then I get error ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect string

I've erased password file and recreated it again but I get the same results

P.S. OS is WIN NT and Oracle 8.1.7

Thank you

[pipo]

what do you have in your tnsnames.ora file ??

[mike73]

try this:

1. use SVRMGRL
2. set your environment to the instance you want to log into
3. CONNECT/INTERNAL
4. if CONNECT/INTERNAL is not working which mean that your password has changed.
5. If your password is changed and you don't know the password, change the password file at ORACLE_HOME\database\pwd.ora. what you need to do here is delete the old password and recreate the new one using ORADIM

let us know if you still have problem

[raghud]

Or else simply if you are in dba group .. Just use connect internal , It will connect you .. Ned not use password or connect string ..

[pipo]

if his prompt is :
c:\>
I really doubt he could be in any group since he's using NT

[raghud]

I don't think so ..

In NT we must have ora_dba group . Programs/admin tools/user manger under that you can see ora_dba group . If he had logged to nT using any account under ora_dba group,he can be connected to oracle without any password or connect string ..Usually I won't use any password or connect string .. Just connect internal ,if prompted for password just return . Now on 9i release just connect sys as sysdba ..

[Tarry]

Aljaz,
Not trying to go off tangents follow these steps meticulously,

1. In configuration box(my computer) /services, you must have oraclestart and oraclestart start , if not start them.

2. start your TNSLSNR80 from services or thru cmd.exe prompt lsnrctl8x , then check status first ,if not started promt start.

3. Test your connection to the database , thry net8 utility.
create it if you didn't create it. Depending on how you created the instance(i prefer to use dbassistent , then custom creation helps you create you internal account...), but anyways keep all your passwords and test the connection here...
modify your lsnr.ora, tnsnames.ora files if required.

4. Tip:also check the registry, i prefer to have it clean from previous installations...

5. Let us know here if this worked.

Cheers!!!!!

Tarun