I'm trying to install Oracle9i Application Server, and when it comes to the portal configuration part and when i provide the connection information (HOST:PORT NUMBER:CONNECTION STRING), a message pops up stating that it can not connect to the database.
well i can connect to the database from the same machine where i'm installing the application server using "system" user, but as "sys" user i have to connect as a sysdba.
what can i do?
thanks in advance.
Toggle the value of o7_dictionary_accessibility in your init.ora. Bounce the db. Now try connecting as sys without giving 'as sysdba'. If this succeeds, you can continue with portal config...
Execuse my english ggnanaraj, but what do you mean by Toggle, and bounce?
i don't seem to have a o7_dictionary_accessibility parameter in my init.ora file.
Thanks for your reply.
Login in as 'sys as sysdba' and at sql prompt type
SQL> show parameter o7_dictionary_accessibility
(note it is o7 (alphabet o 7 NOT zero 7)
If it is false include an entry in your init.ora as...
Now, shutdown your database and restart again.
Connect to sys without 'as sysdba' now.
[Edited by ggnanaraj on 07-06-2002 at 01:24 PM]
I tried what you said, and when i started up the database i got ORA-27101 shared memory realm does not exist.
what can i do?
anyone has an answer for my problem?
Make sure u'r ORACLE_SID, ORACLE_HOME is set to correct value. Moreover, connect using service name...
BTW, what OS are u using ?
So, also o7_dictionary_accessibility=true should be set.
I didn't mean to abuse, i'm really sorry if i hurt anyone.
Originally posted by pando
plz dont abuse
Click Here to Expand Forum to Full Width