Portal configuartion

[hany]

hi guys,
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.

[hany]

any clue?

[ggnanaraj]

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...

HTS.

[hany]

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.

[ggnanaraj]

Hi

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...

o7_dictionary_accessibility=true

Now, shutdown your database and restart again.

Connect to sys without 'as sysdba' now.

HTH.



[Edited by ggnanaraj on 07-06-2002 at 01:24 PM]

[hany]

hi ggnanaraj,
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?

[hany]

anyone has an answer for my problem?

[pando]

plz dont abuse

[ggnanaraj]

Hi

Make sure u'r ORACLE_SID, ORACLE_HOME is set to correct value. Moreover, connect using service name...

connect sys@tst

BTW, what OS are u using ?

So, also o7_dictionary_accessibility=true should be set.

Cheers.

[hany]

Originally posted by pando
plz dont abuse

I didn't mean to abuse, i'm really sorry if i hurt anyone.