948113 wrote:Post the command you are executing, the error you are getting, and the version of Oracle you are using
I tried to use SQL plus to trace what happens in the database (what queries are executed and such) when a certain function is performed in our information system...
But i cant get it working...
I cant seem to log in using our sysdba account...
probably im doing something wrong...
When i start the SQL plus
I login using a password (not the SYSDBA password)
I use the following syntax
So for example for our test database
i use test@database
then the password...
And i get connected
But then when i try to find out the specific id for a specific user online at the moment i get errors (sorry for the bad explanation)...
Is there any way to monitor ALL what happens in the database?
for a period of time...
(since i am the only one online at the test database, then i wont have to filter anyhing...
any help is appreciated:)
948113 wrote:Check your tnsnames.ora file to see if "sans" is defined there - I suspect not, or perhaps "sans" is not quite the correct spelling
but when i try this one things stop working:-p
connect system/manager@sans as sysdba
I get an error saying "ORA-12154 TNS: Could not resolve the connect identifier specified
948113 wrote:Better. Make sure the login account has connect and the other usual privileges too
I suspect that sans = the database name?
If i change and write this
connect system@databasename as sysdba
and then enter the sysdba password
then i get insufficent priviligies...
(the sysdba account is used in other places and there it works just fine...)